Pareto

[sokekos]

Hi,

I am working in a pareto chart, but the accumulated volume and accumulated % do not work correctly:

These are the measures that I am using:

Ranking Vol = if([Crop Volume]>0,RANKX(all('Customer Master Data'[Customer Nickname]),[Crop Volume]))

Accumulated Volume = CALCULATE([Crop Volume],TOPN([Ranking Vol],all('Customer Master Data'[Customer Nickname]),[Crop Volume]))

Accumulated % Vol = [Accumulated Volume]/CALCULATE([Crop Volume],all('Customer Master Data'[Customer Nickname]))

For some of the customers summarize but for others it does not.

Can you please help me here?

Thank you

Regards

[amitchandak]

@sokekos , Try using window function

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw