Forum Discussion
Calculated columns for Ranking of Customers by Distributor as well as on overall sales
I am preparing a dashboard in Power BI Desktop and have daily sales data of our distributors and their chemists. We have many distributors and every distributor have thousands of chemist (as their cu...
Hi Anonymous
I made changes of 2 of the columns formula:
Chemist Rank within Distributor = RANKX(FILTER('Table',[Distributor Code]=EARLIER('Table'[Distributor Code])),[Column],,DESC,Dense)Overall Chemist Rank = RANKX('Table',[Column 3],,DESC,Dense)Other 2 columns remained:
Pbix attached.
Thanks for your time and the effort. Actually, the ranks are not in agreement with my sample data. If a distributor have only three chemists then obviously their ranks will be 1, 2 & 3 and same is the case in over all ranking.
Could you please devise a solution which matches my results.
Regards,
v-diye-msft
Community Support
Community SupportHi Anonymous
I made changes of 2 of the columns formula:
Chemist Rank within Distributor =
RANKX(FILTER('Table',[Distributor Code]=EARLIER('Table'[Distributor Code])),[Column],,DESC,Dense)
Overall Chemist Rank = RANKX('Table',[Column 3],,DESC,Dense)
Other 2 columns remained:
Pbix attached.