RANKX showing tie for non-tied values

• Steven.Grzybowski

  Hall of Fame

  Points: 3214

  More actions

  July 31, 2018 at 8:23 am

  #355183

  I have created a measure for Customer rank. This measure is as follows : 
  
CustRank:=RANKX(ALL(Dim_Customer),CALCULATE([Revenue]))

  The Revenue Measure is calculated as Follows
  
Revenue:= CALCULATE(-1*SUM(Fact_Transaction[GLL_Amount]),Dim_COA[COA_Type] = "Revenue")


  When I look at the data in Power BI However, I am seeing a tie for customers that do not have the same amount of revenue.  I have attached a screenshot showing the faulty Tie that is occurring on this measure. 

• Steven.Grzybowski

  Hall of Fame

  Points: 3214

  More actions

  July 31, 2018 at 9:22 am

  #1999705

  Turns out that it was just that I was using a non-unique value for the Rows.