Top N values

[Brighton10]

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

Total responses = [report_a_bug2] + [Confirmed] + [QRScan] + [upload log files]

[daxer-almighty · Accepted solution]

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.

[Brighton10]

Thanks @daxer-almighty Thats a pretty cool hack around it.😊

[daxer-almighty]

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.

[Brighton10]

@daxer-almighty  Thanks for your response. Do you care to show an example