How to find accounts from where we get 80% of rev...

arvindyadav · ‎11-12-2019

Hi Team,

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

Thanks,

Arvind

PaulDBrown · ‎11-12-2019

I usually use a combination of RANKX and TOPN.

This link might be useful:

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.

arvindyadav · ‎11-12-2019

Did not get expected things from your link?

May you please send me one sample pbix file?

Thanks,

Arvind

PaulDBrown · ‎11-12-2019

Here you go:

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.

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