Forum Discussion

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper 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...
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.

     

     

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
giorgiokatr wrote:

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

giorgiokatr wrote:

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

giorgiokatr

Even with the attached pbix file, your description is not clear for me. Could you show the expected output with some snapshots?

    • Bordalos's avatar
      Bordalos
      Icon for Helper I rankHelper I
      8 years ago

      In order to better understand you issue please share how are you claculating the rank. 

      • giorgiokatr's avatar
        giorgiokatr
        Icon for Helper V rankHelper V
        8 years ago

        i want to calculate sales so i created a measure

        salesamount = CALCULATE(SUM(Table1[sales]))

        then i used

        Rank = RANKX(ALL(Table1[branch]),CALCULATE([salesamount],ALLEXCEPT(Table1,Table1[branch],Table1[area],Table1[sector])),,ASC,Dense)

        the "hierarchy" in matrix rows is sector>area>branch

        but rank is wrong for negative when i filter for example sector or area in slicers

        i also used

        RANKX(ALL(Table1[branch]),CALCULATE([salesamount]),,ASC,Dense)

        but same problem

        rank goes 1,2 then in negative values rank is 4 instead of 3

        this happen when i filter with a slicer

        all branch rank (unfiltered area and sector ) is right