SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in ...

Read More

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI

In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will ...

Read More

Quick DAX : Word count

Posted by on Oct 13, 2018 in DAX, Power BI | 9 Comments

Here is a technique you might consider if you need to split text down to individual words.  This could be used to help count, rank or otherwise aggregate the words in some longer text.  The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between ...

Read More

Fun with DAX – Minesweeper

Posted by on Oct 4, 2018 in DAX, Power BI | 6 Comments

The latest addition to my recent series of DAX based games is the classic Minesweeper game.  This is the game where you are presented with a 9 x 9 matrix of squares.  There are 10 hidden mines and you can either step on a square or place a flag where you think there might be ...

Read More

Quick DAX : Convert to Roman Numerials

Posted by on Aug 9, 2018 in DAX, Power BI | No Comments

One of the biggest holes in DAX today is the lack of a native function that allows you to convert a decimal number to its roman number equivalent.  Excel has a ROMAN() function so I thought it was about time to share one approach to converting decimal numbers to Roman.  I can feel a collective ...

Read More