Forum Discussion
Pareto
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
1 Reply
- amitchandakSuper User
Anonymous , 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