Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.