BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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
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:
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).
- Calculating the percentage share of the highest value in DAX (this blog)
- The single measure solution
- A solution using a calculated column