Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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!!
Not able to respond to the above comments, sorry for that. Its also not allowing to upload any pbix file or tables here.
Thanks!
@Anonymous , I think you should explore calculation groups
https://www.sqlbi.com/articles/introducing-calculation-groups/
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.?
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |