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
    9 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
9 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?

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

please check two attached picsthank Eric_Zhang

  • Bordalos's avatar
    Bordalos
    Icon for Helper I rankHelper I
    9 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
      9 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