Forum Discussion
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 bottom 20 it shows more than 20 customers because the measure shows the same value (Total response = 1)for all those customers. Is there a way just to visualize only top 20 not considering N>20?
My measure is basically summing up other measures then i use it as a filter on customer name
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.
4 Replies
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.
Thanks daxer-almighty Thats a pretty cool hack around it.😊
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.
daxer-almighty Thanks for your response. Do you care to show an example
