Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.