Below is my data PersonPriceCallsMeasure - Price/CallsTom6319.8510261.95931373Harry3345.95956.71016949Gina7678.5513756.04781022George10882.3520852.31899038Arnold9239.5519746.90126904Frank8605.618446.76956522Peter9338.820645.33398058 Below is my code for ranking RANKX (ALLSELECTED(Table ), CALCULATE(SUMX(Table,Table[Measure - Price/Calls]))) and I keep getting everything as Rank 1. PersonPriceCallsMeasure - Price/CallsRankTom6319.8510261.959313731Harry3345.95956.710169491Gina7678.5513756.047810221George10882.3520852.318990381Arnold9239.5519746.901269041Frank8605.618446.769565221Peter9338.820645.333980581 Below is what I am looking for PersonPriceCallsMeasure - Price/CallsRankTom6319.8510261.959313731Harry3345.95956.710169492Gina7678.5513756.047810223George10882.3520852.318990384Arnold9239.5519746.901269045Frank8605.618446.769565226Peter9338.820645.333980587 Please help.

Anonymous

Not applicable

7 years ago

Solved

need help with Ranking in DAX

Below is my data

Below is my code for ranking

RANKX (ALLSELECTED(Table ), CALCULATE(SUMX(Table,Table[Measure - Price/Calls])))

and I keep getting everything as Rank 1.

Below is what I am looking for

Please help.

Anonymous

Oh, I thought it was just a table and each person had one piece of data.

You may try the followings:

RANKX( ALLSELECTED( Table), 
       CALCULATE( [Price divided by Calls], ALLEXCEPT( Table, Table[Person])),
       ,
       DESC,
       Dense)