topic Re: Dynamic Ranking of multiple measures in DAX Commands and Tips

Dynamic Ranking of multiple measures

Anonymous — Thu, 07 Jan 2021 14:22:26 GMT

I have calculated around 16 coefficient of correlation values using quick measures. So now I have 16 measures, I want to Rank these measures. Make it dynamic in nature i.e. if there is a change in any filters the coefficient of correlation should automatically change and I need to get the ranks of all the measures(all the 16 Coeffecint of correlations).

Thanks in advance!!

Re: Dynamic Ranking of multiple measures

littlemojopuppy — Thu, 07 Jan 2021 14:43:22 GMT

Wow...can you provide sample data and the DAX for the measures? A sample pbix would be easier.

Question: in what context are you trying to compare them? Meaning are all 16 for locations, products, etc.?

Re: Dynamic Ranking of multiple measures

amitchandak — Thu, 07 Jan 2021 15:49:43 GMT

Anonymous , I think you should explore calculation groups

https://www.sqlbi.com/articles/introducing-calculation-groups/

Re: Dynamic Ranking of multiple measures

Anonymous — Tue, 12 Jan 2021 04:25:05 GMT

Not able to respond to the above comments, sorry for that. Its also not allowing to upload any pbix file or tables here.

Thanks!