Forum Discussion

anjugauriunni's avatar
anjugauriunni
Frequent Visitor
2 years ago

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...
Need Help
Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, anjugauriunni 

try below

item rank =
var a = addcolumn(
          values(brand[brand]),
         "amt", [total sales]
        )
 return
rankx(
    a,[amt]
)