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 =
FILTER(
ADDCOLUMNS(
SUMMARIZECOLUMNS(
customers[CustomerID],customers[Country],
fOrders,"totalsales",[Total Sales]),
"ranksalesbycid", AllMeasures[rank custID by sales],
"customerIDRT", AllMeasures[custID Sales RT]),
[customerIDRT]<=totalsales80country && [Country]=selectedcountry)
RETURN
MAXX(tablecustomerRT80,[customerIDRT])
DYNAMIC PARETO: Total sales for the TOP n customers selected
Rank Top customers sales slicer =
VAR slicerselect = SELECTEDVALUE(RankSlicer[Rankslicer])
RETURN
IF( [Rank all custID] <= slicerselect,
CALCULATE([Total Sales],
TOPN(slicerselect, VALUES(customers[CompanyName]), [Total Sales])))
(Kudos and big thanks to @v-janeyg-msft who was a great help to find the solution)
eyJrIjoiNDg0ZTU5NGUtMWQwZS00MzQ0LTk0NjctMmRmNmM2MWJkYTNkIiwidCI6IjU0OGVmYThjLWI1MzEtNDRjOS05MGY4LTAzZDc4MTdkMzdmZSJ9
