No of customer who meets percentage of sales

Prathana — Wed, 18 Jan 2023 18:09:25 GMT

I want to show count of customers who excced the percentage of total sales. Where Percentage we need to keep in parameter (slicer).

Re: No of customer who meets percentage of sales

Anonymous — Wed, 18 Jan 2023 18:38:45 GMT

Hello Prathana not sure if i understood well but you couls try this

Calculate(count(table[customer],[percentage sales of each customer] > [percentage of total sales]))

If you want the percentage of each customer, then

Percentage of each customer =

VAR sales = Calculate(sum(sales))

Var allsales= Calculate(sum(sales),all(table))

Return

Divide(sales,allsales,0)