Forum Discussion
Brighton10
5 years agoHelper II
Top N values
Hi I have a measure that I am using to filter my data to visualize top 20 customers by Fullname. The measure works well for top 20 because Total response has different values but if i choose bot...
- 5 years ago
Have a look at this: TopN ties: handling ties when using visual level f... - Microsoft Power BI Community
Look for the answer coming from @krogers.
daxer-almighty
5 years agoSolution Sage
Yeah, that's easy. Create a measure that will order the customers not only by Total Responses but also will break ties using, for instance, customer id. Once you have such a measure, use it to filter the TOP20 customers.
- Brighton105 years agoHelper II
daxer-almighty Thanks for your response. Do you care to show an example