Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
sokekos
New Member

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 1
amitchandak
Super User
Super User

@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

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.