topic Re: Rankx issue in DAX Commands and Tips

Rankx issue

sandman3300 — Tue, 13 Sep 2022 12:10:31 GMT

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.

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 12:48:53 GMT

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

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 12:59:15 GMT

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 13:13:31 GMT

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

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 13:40:05 GMT

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 13:55:33 GMT

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

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 14:10:56 GMT

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.

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 14:15:58 GMT

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

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 14:24:53 GMT

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

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 14:26:41 GMT

that is really weird

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 14:41:06 GMT

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.

Re: Rankx issue

johnt75 — Tue, 13 Sep 2022 14:46:19 GMT

I'd go for your ALLNOBLANKROW solution.

Re: Rankx issue

sandman3300 — Tue, 13 Sep 2022 17:17:36 GMT

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