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.

raharebecca's avatar
raharebecca
Frequent Visitor
7 years ago

Hi! I have 7 Regions and when I have all of them listed in a table they are ranked correctly. However, when I put in a region slicer and select one region, the rank increases by one. So my region ranked 7th, when selected in the slicer  shows a rank of 8 even though there are only 7 regions. I can't understand why it increases only when one is selected. I have tried a million different versions of formulas but the rank still always increases. Any insight would be much appreciated.