Archive - Blog Posts on SUMX

When to Use SUM() vs SUMX() - Level: Beginners/Intermediate It has been 2 years since I first wrote an article about SUM() vs SUMX().  I decided to write a new article to refresh this topic and add in the things I have learnt over the last 2 years. SUM() vs SUMX() First let me start with an overview of both of these […] 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 deeper to the specifics on how to use some of the more useful DAX query functions.  In this final article […] 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 to query a database and return a table of data as a result.  In this article I am going to […] Read More
Measures on Rows – Here is How I did it - Level: Intermediate You may or may not be aware that it is not possible to put Measures on rows in a Matrix in Power BI. But I came up with a trick that makes it possible, so read on to find out how. Measures Can Only be Placed on Columns First the problem. The only […] 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 is the topic of today’s post. Count the Working Days Between Two Dates The requirement was to count the working […] Read More