Forum Discussion

giorgiokatr's avatar
giorgiokatr
Helper V
8 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 4

see attached pbix

https://drive.google.com/open?id=0Bw-_YmJ3Q49gTnpKTnQzNktTZ1k

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.

     

     

9 Replies