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

[arvindyadav]

Hi Team,

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

Thanks,

Arvind

[PaulDBrown]

@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/ 

[arvindyadav]

Hi @PaulDBrown ,

Did not get expected things from your link?

May you please send me one sample pbix file?

Thanks,

Arvind

[PaulDBrown]

@arvindyadav 

Here you go:

Top 80% Sales