Forum Discussion

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper V
9 years ago
Solved

wrong rank in negative values

wrong rank in negative values   when i select sector and area hierarchy rank for negative values (category bikes) goes wrong after branch 6 branch 2 should have rank 2 also rank should start from...
Need Help
  • Bordalos's avatar
    Bordalos
    8 years ago

    giorgiokatr what about :

     

    First create a measure to sum [Total USD], like :

    Sum_USD = SUM(temp[Total USD])

    Then rank all table  and use the last measure as expression:

     

     

    Rank = RANKX(ALLSELECTED(temp),[Sum_USD],,ASC,Dense)

     

    No filters applied

    Filter

    cat = {a,b}

     

    filter

     

    firstCat={1} and

    cat={b,c}

     

     

    In this way you will rank the values according to what is selected.