02-06-2022 07:26 AM
We all know the Pareto principle: 80% of a result comes from 20% of the input. This is not only valid in business, there are also multiple examples in nature too.
But how about you want to know, what percentage of sales your top n customers made using a slicer?
Beyond pareto gives the answer. In order to return the numbers as scalar values, you need to make use of a virtual table, from which you then return aggregated values for the card/text fields.
CLASSIC PARETO: Total sales for the 80% value selected county
Summarize customerID selected country 80% salesvalue =
VAR selectedcountry = SELECTEDVALUE(customers[Country])
VAR totalsales80country = CALCULATE([Total Sales]*0.8, FILTER(fOrders,fOrders[ShipCountry]=selectedcountry))
VAR tablecustomerRT80 =
"ranksalesbycid", AllMeasures[rank custID by sales],
"customerIDRT", AllMeasures[custID Sales RT]),
[customerIDRT]<=totalsales80country && [Country]=selectedcountry)
DYNAMIC PARETO: Total sales for the TOP n customers selected