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
Community Support
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.