Customers who represent a certain percentage of the revenue

[marakud971]

Hello everyone, I'm requesting your help with the following problem.

I want a percentage slicer that allows me to filter a chart.
The goal is to display the customers who represent a certain percentage of the revenue.

For example, if I select 40% in my slicer, I will see the TOP N customers who represent 40% of my revenue. (sum of all customers).

I have created the following table for my slicer: TableSlicer (%) = GENERATESERIES(0,1,0.1)

I'm having trouble creating a measure that filters my Top N corresponding to this percentage. What should I do?

Thank you so much.

[lbendlin]

Have a sorted list of customers and their revenue, largest first.  Run a cumulative sum through that list and cut off when you reach 40 %.  All customers before reaching the threshold can return something (like their revenue), all others can return BLANK() so their rows would be suppressed during rendering.

Check DAXPatterns.com for Pareto patterns.