SUMX - Excelerator BI

SUMX

Simple Filters and Syntax Sugar in DAX

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”.  Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use …

Simple Filters and Syntax Sugar in DAX Read More

When to Use SUM() vs SUMX()

Level: Beginners/Intermediate (Updated Oct 2018). This is a further (third) update/edit to an article I first wrote 3 years back and then updated a year back.  When I update my articles I simply change the …

When to Use SUM() vs SUMX() Read More

Uses for DAX as a Query Language

Level: Intermediate This is the final article in my series about DAX as a Query Language.  In my first article I introduced DAX as a Query Language and then in my second article I went in …

Uses for DAX as a Query Language Read More

DAX as a Query Language Part 2

Level: Intermediate In my last article I introduced DAX as a Query Language and explained why learning to query your data model can be useful.  I covered the basics about using a tool like DAX Studio …

DAX as a Query Language Part 2 Read More

Measures on Rows – Here is How I did it

Level: Intermediate Update: 2019. You can now do this natively in a Matrix, but this is still a good trick that can be used to solve various problems. You may or may not be aware …

Measures on Rows – Here is How I did it Read More

A Double CALCULATE Solves a SUMX Problem

Level: Intermediate I helped a member at http://powerpivotforum.com.au with a problem last week that ended with an interesting solution.  The explanation of how it worked was a bit complicated and worthy of sharing, hence this …

A Double CALCULATE Solves a SUMX Problem Read More

Scroll to Top