Forum Discussion

raharebecca's avatar
raharebecca
Frequent Visitor
7 years ago
Solved

Rank not staying static

Hi!   I have 8 regions that I want to rank based on a measure. When I have all the regions selected the rank is correct. However, when I filter for one region, then rank increases by one. I think m...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi raharebecca 

    If [Loss] is a measure and you want to ignore blank regions, you could create a measure as below

    Measure = RANKX(FILTER(ALLSELECTED('Table'),'Table'[region]<>BLANK()),[loss],,ASC,Dense)

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi raharebecca 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

 

Best Regards

Maggie