Forum Discussion

rlansing's avatar
rlansing
Resolver I
10 years ago
Solved

RANKX question

Hello, I am refining a DAX measure that calculates a product's rank within a group of products. Here is my current measure: $ Rnk = IF([$ Vol] > 0 && HASONEVALUE( Products[Product] ),    RANKX ( A...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    Maybe I am missing something. Why can't you use this

     

    Rankx(all(product), etc

     

     

MattAllington's avatar
MattAllington
Community Champion
10 years ago

Maybe I am missing something. Why can't you use this

 

Rankx(all(product), etc

 

 

rlansing's avatar
rlansing
Resolver I
10 years ago

Thanks Matt. Now it seems trivial. Because I just want to honor the filter on the Sub-Category, I am now using

RANKX (ALLEXCEPT (Products, Products[Sub-Cat]), [$ Vol] ) etc....

 

I was trying to use ALL but applied it to the Fact table not the dimension table.