topic Re: RANKX with visual filters in DAX Commands and Tips

RANKX with visual filters

poojithas — Tue, 04 Apr 2023 09:53:57 GMT

Hi All,

I have a requirement to show top 20 values in a table.

For that I have used RANKX function. Code below.

This gives me the correct ranking based on the field volume.

But, after I apply Top 20 filter, the ranking is incorrect. The Ranks are repeated and the values are not in the expected order.

This is happening due to the RL12 filter.

I am only including data where RL12="Y". There are other visual filters as well.
So, where ever there are no records for RL12=Y, the rank is getting skipped.

Could someone please suggest on how this can be fixed and show all the ranks in order without any repetition.

Thank you

Poojitha

Re: RANKX with visual filters

tamerj1 — Tue, 04 Apr 2023 09:56:27 GMT

Hi poojithas
Try by replacing ALL with ALLSELECTED

Re: RANKX with visual filters

poojithas — Tue, 04 Apr 2023 10:25:31 GMT

tamerj1 : Tried ALLSELECTED as well, and the results are same as ALL.

The results are not as expected

Re: RANKX with visual filters

tamerj1 — Tue, 04 Apr 2023 11:22:47 GMT

poojithas
Ok. Please try

Rank = RANKX ( CALCULATETABLE ( SUMMARIZE ( NTN_GRAPHS, NTN_GRAPHS[GRANDPARENT], NTN_GRAPHS[GRANDPARENT] ), ALLSELECTED () ), [Volume (k1)] )

Re: RANKX with visual filters

poojithas — Tue, 04 Apr 2023 11:49:05 GMT

tamerj1 : Thanks for the quick response. I have tried the above logic and the results are again same as before . Please find the screenshot below:

Re: RANKX with visual filters

tamerj1 — Tue, 04 Apr 2023 12:26:32 GMT

poojithas

What is the DAX of [Volume (k1)]?

Re: RANKX with visual filters

poojithas — Tue, 04 Apr 2023 12:30:28 GMT

tamerj1 : It is volume *0.001

Re: RANKX with visual filters

poojithas — Wed, 05 Apr 2023 07:21:53 GMT

tamerj1
There was a visual filter for the field "Type" where the logic was concatenate(comments,ntn/non-ntn) and this had the output as below: I was restricting this to only show Regular NTN and Premium NTN.

Regular NTN

Regular Non-NTN

PremiumI NTN

Premium Non-NTN

Non-Premium NTN

Non-Premium Non-NTN

I created another column with the logic as if type=Regular NTN and Premium NTN then include else exclude. I used this field instead of TYPE in the visual filter. This fixed the issue with Ranking.
Thanks for the responses.