Forum Discussion
Rankx function is not returning correct values when used with dimension table
Hi, I made a item rank dax Item rank = RANKX(All(Brand[Brand]), [Total Sales]) Brand is one of the dimension table containing brand name and brand id. Fact table contains brand id. The above funct...
Error showing "All arguments of the ALLSELECTED function must be from the same table"
or try this
Measure = RANKX (GENERATE(ALLSELECTED(Brand[Brand]),ALLSELECTED(Fact table[ Brand ID])), [Total Sales])