Browse 554 attributed reviews, viewable separately for our classroom and online training
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.

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

Posted by Andy Brown on 22 January 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

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:

Percentage of highest region

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).

  1. Calculating the percentage share of the highest value in DAX (this blog)
  2. The single measure solution
  3. A solution using a calculated column
This blog has 0 threads Add post