This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

How to use DAX to show for each row of a table its share of the maximum value Part one of a three-part series of blogs
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem. Calculating the percentage share of the highest value in DAX (this blog) The single measure solution A solution using a calculated column

How to use DAX to show for each row of a table its share of the maximum value

Part one of a three-part series of blogs

How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.

Calculating the percentage share of the highest value in DAX (this blog)
The single measure solution
A solution using a calculated column

Posted by Andy Brown on 22 January 2021

Calculating the percentage share of the highest value in DAX

Another course, another interesting question (thanks Darren!) and another blog ... this time how to show this statistic:

For each region we want to show its sales as a percentage of the sales of the highest region.

How hard can this be? As it turns out, not that straightforward (unless I'm missing a more obvious method, in which case please let me know). I've come up with two solutions:

Solution	Notes
Single measure	Do the whole thing in a single measure in DAX
Stepping stone	Store the highest sales for each region in a calculated column

I hate reading blogs on DAX which don't explain their workings, so I've built up the measure in each blog bit by bit so you can follow along (or open the final Power BI report, which contains the data and the final measures).