cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

Pareto Chart by Period

I have 5yrs of historical data where I need to provide a chart that tells me how many 'Customers' contributed to the Top 80% of sales

I have managed to get this far by using RANKX (Refer image)

 

Capture2.JPG

 

Issues

1) I dont know how to write a DAX that only COUNT the number of customers giving me Top 80% of Sales (highlighted in Green in the image). I dont want to use to use the FILTER pane

2) I dont know how to write a DAX to help me provide below (including a bar chart)

 FY16FY17FY18FY19FY20
No. Customers contributing to Top80% of Sales1008595110115
1 REPLY 1
Highlighted
Resolver II
Resolver II

Re: Pareto Chart by Period

1RANK = RANKX(ALL(lookupPartner[Partner Id w Name]),[Actuals Historical],,DESC)
 
Actuals Historical Cumulative = CALCULATE([Actuals Historical],TOPN([1RANK],ALLSELECTED(lookupPartner[Partner Id w Name]),[Actuals Historical]))
 
Actuals Historical Cumulative % = DIVIDE([Actuals Historical Cumulative], [Actuals Historical (partnerID all selected)])

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors