Monthly performance of 80% Sale by product

[tracytran91]

Hi friends, 

I did a pareto chart which showed up SKU made up 80% Sales. The measure Cumulative SKU % worked well. 

Cumulative SKU % = 
var total =  CALCULATE ([Sales], ALL( D_product[code]))
var current1 = [Sales]
var summarizedTable=
 SUMMARIZE(ALLSELECTED(D_product),D_product[code] ,"NetSales1",[Sales])
var cummlativeSum = 
 SUMX(FILTER(summarizedTable,[NetSales1]>=current1),[NetSales1])
return cummlativeSum/total

Then now, I would like to have the column chart like this to show up monthly performance of 80% Sale by product. 

I created the  measure Sales of 80% SKU. It took over 10 mins but it had not showed up the chart. 

Sales of 80% SKU = 
     CALCULATE(
         [Sales],
         FILTER(ALL(D_product),[Cumulative SKU %] <= 0.8))

Could anyone help me regarding this issue? 

Highly appreciated your help. 

[tracytran91 · Accepted solution]

I used this simple trick and worked. 

I put Product and Month in the shared Axis. Sale will be the values.

[v-xulin-mstf]

Hi @tracytran91

Without knowing the structure of your data, try measure as:

Sales of 80% SKU = 
Sumx(
     filter(
          ALL(D_product),
          month(D_product)=month(max(D_product))
          ),
     CALCULATE(
         [Sales],
         FILTER((D_product),[Cumulative SKU %] <= 0.8))
)

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@tracytran91 , refer if these can help

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/