Forum Discussion
Rankx multiple tables
Hi, I have a table visualization pulling in data from multiple connected tables and a measure and I am seeing unexpected results when adding a rankx measure. RANKX ( ALLSELECTED ('MeasureTableX'...
Hard to diagnose without some dummy data/ideally an example pbix. However... straight away I would look to remove the ALLEXCEPT lines and instead use an ALL / VALUES approach. Have a read of https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/ you tend to avoid a lot of pain that way,
How are the tables related. Can you describe MeasureTableX? I suspect that might be causing the issue as you really want to rank over a table at the same grain as your visual.
Hi, MeasureTableX is just a table of measures...so not really a table. Not sure if rankx syntax would take a table of measures vs an actual table.
