Dynamic Ranking of multiple measures

Question

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!!

littlemojopuppy · Answer

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.?

amitchandak · Answer

Anonymous , I think you should explore calculation groups
https://www.sqlbi.com/articles/introducing-calculation-groups/

anonymous · Answer

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

Forum Discussion

Dynamic Ranking of multiple measures

3 Replies

Related content

Dynamic measure filtering

Dynamic Measure developement

Multiple measures in matrix by year

Dynamic Filter creation based on multiple criteria

How to show multiple metrics/measures in a visual?