Forum Discussion

sandman3300's avatar
sandman3300
New Member
4 years ago

Rankx issue

Dear experts, I am trying to figure out what is wrong with my dax measure.   I don't understand why I am getting 1 for all ranks.      
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You are removing the filter from the Exposure column but there is also a filter on the Observation column. Try

Ranking measure =
RANKX (
    ALL ( 'Safety stats' ),
    CALCULATE ( SUM ( 'Safety stats'[Observations] ) )
)
sandman3300's avatar
sandman3300
New Member
4 years ago

 

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    Hmm, that works for me, and notice how the Others row is now getting a value. Use Performance Analyzer to get the code generated for the table and paste it into DAX Studio. That will tell you if any other filters are being applied which might affect the results, and if you execute the query you can compare the results from DAX Studio with Power BI, which should of course be the same

    • sandman3300's avatar
      sandman3300
      New Member
      4 years ago

       

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        4 years ago

        Nothing unusual there. Is it possible to share a PBIX with any confidential information removed ?