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.

 

 

 

12 Replies

  • 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] ) )
)
      • 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