Rankx issue

[sandman3300]

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]

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]

[johnt75]

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]

[johnt75]

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

[sandman3300]

One more piece of information I created another table 

Exposures = ALLNOBLANKROW('Safety Stats'[Exposure])

I used the exposure column from the newly created table.  And the ranking started working suddenly.  At this point I think it is some kind bug.

[johnt75]

as long as its working, thats the main thing.

the other relationship going into the Safety Stats table, is that single direction or bidirectional? if its bidirectional that could be causing an issue

[sandman3300]

I just deleted all other tables.  And it is still not working.

[johnt75]

that is really weird

[sandman3300]

I exported the table to excel and created a new power bi file with that source and It did not work.

I removed some other columns and then it started working.

[johnt75]

I'd go for your ALLNOBLANKROW solution.

[sandman3300]

Thanks for looking into this.  I was very confused for a long time.