562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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:
|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).
|Parts of this blog|
25 Aytoun Street