Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
arvindyadav
Post Partisan
Post Partisan

How to find accounts from where we get 80% of revenue by ranking

‎11-12-2019 02:08 AM

Hi Team,

 

How to find accounts from where we get 80% of revenue by ranking.

 

Thanks,

Arvind

Labels:
Message 1 of 4
502 Views
0
3 REPLIES 3
PaulDBrown
Community Champion
Community Champion

‎11-12-2019 02:35 AM

@arvindyadav 

 

I usually use a combination of RANKX and TOPN.

 

This link might be useful:

 

https://www.dutchdatadude.com/power-bi-pro-tip-pareto-analysis-with-dax/ 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Message 2 of 4
495 Views
0
arvindyadav
Post Partisan
Post Partisan
In response to PaulDBrown

‎11-12-2019 02:55 AM

Hi @PaulDBrown ,

 

Did not get expected things from your link?

May you please send me one sample pbix file?

 

Thanks,

Arvind

Message 3 of 4
467 Views
0
PaulDBrown
Community Champion
Community Champion
In response to arvindyadav

‎11-12-2019 03:55 AM

@arvindyadav 

 

Here you go:

 

Top 80% Sales 

 

Top 80%.JPG

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Message 4 of 4
457 Views
0

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

View All
Top Solution Authors
View All