Unable to get top 20% customers based on Sales

[Anonymous]

Hello Fam,

I am using below two measures to calculate Top 20% customers based on sales:-

Unique Customers = DISTINCTCOUNT(BI_SALESFACT[CUSTOMER_NO])

Top 20% Customers = IF(ISBLANK([NetSales_Cal]),

BLANK(),

IF(RANKX(ALL(BI_SALESFACT),[NetSales_Cal], , DESC) < (CALCULATE([Unique Customers],ALL(BI_SALESFACT)) * 0.2),

[NetSales_Cal],

BLANK()))

But, unfortunately it is throwing below attached error. 
Any help in rectifying the error will be appreciated.

Regards,
Sumit

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Sum_group =
SUMX(FILTER(ALL(BI_SALESFACT),'BI_SALESFACT'[CUSTOMER_NO]=MAX('BI_SALESFACT'[CUSTOMER_NO])),[NetSales_Cal])

rank =
RANKX(ALLSELECTED(BI_SALESFACT),[Sum_group],,DESC)

Flag =
var _Discount =
CALCULATE(DISTINCTCOUNT('BI_SALESFACT'[CUSTOMER_NO]),ALL(BI_SALESFACT)) / 20
return
IF(
    [rank] <=_Discount,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Anonymous , refer to the approach in this blog, that can help

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/