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