Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issues with rankx

Hello. I have 5 product categories and i want to rank them from 1 to 5 according to their sales but the data integrity is not accurate 100% and I would like to ask for some help. This is my dax func...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Anonymous try to replace part ALL in

ALL ( dimProducts[Category_Name]) with ALLSELECTED ( dimProducts[Category_Name])

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    unfortunately didnt help, it ranks every category as 1