Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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