Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Another simple ask.
In the service (so no DAX) I am trying to show the top sales person by region. I have all the measures I need, but it seems impossible to use the Top N. Each region has about 10 sales people and I have 10 regions, I want to show the top sales person from each region. Selecting the region as a filter with Top N (1) based on sales variance simply gives me 3 values all from the region, none of which make any sense.
Any idea's?
Solved! Go to Solution.
Hi @MattN4
Do you want to show the top 1 sales person from each region?
If you create a rank measure, than you can filter the "rank" to show values of 1.
Below is my example.
Best Regards
Maggie
Hi @MattN4
Do you want to show the top 1 sales person from each region?
If you create a rank measure, than you can filter the "rank" to show values of 1.
Below is my example.
Best Regards
Maggie
Many thanks this worked.
Just to add, I added DENSE to the end of formula. This was because in my table I had both positive and negative values. The postive values were fine, the negative values showed out of sequence. DENSE resolved this (but don';t ask me how!).