topic Re: DAX Rank Function is not working when I choose multiple dates from the filter in DAX Commands and Tips

DAX Rank Function is not working when I choose multiple dates from the filter

zenbabasha33 — Thu, 01 Aug 2024 20:05:21 GMT

hi Team,

I have two filter Date and Region. when i choose one date it works we and as expected but if I do multiple date from the filter it isnot working. This is the DAX i am using below.

Rank = RANKX(

ALLSELECTED('Royalty'),

'Royalty'[Adjusted Gross Revenue],

DESC,

Skip

)

any kind of help would be greatly appreciated.

Thanks

Re: DAX Rank Function is not working when I choose multiple dates from the filter

aduguid — Fri, 02 Aug 2024 01:47:45 GMT

Try this measure. If you want to rank across all selected dates without splitting by date, you can ignore the date filter in the ranking context.

Rank = RANKX( ALLSELECTED('Royalty'[Region]), 'Royalty'[Adjusted Gross Revenue], , DESC, Skip )

Re: DAX Rank Function is not working when I choose multiple dates from the filter

zenbabasha33 — Fri, 02 Aug 2024 13:23:52 GMT

Thank you but I alreaddy Tried this one

Re: DAX Rank Function is not working when I choose multiple dates from the filter

asadmd93 — Fri, 02 Aug 2024 14:17:51 GMT

ALLSELECTED function gives you all the rows in a table, ignoring the current context filter, which might be causing the unexpected ranking result when multiple dates are selected. You can use the DAX formula below to respect the current filter context for the date.

Rank = RANKX( ALLSELECTED('Royalty'[Date], 'Royalty'[Region]), 'Royalty'[Adjusted Gross Revenue], , DESC, Skip )

Another approach is to use ALL on the date column specifically, rather than the entire table, which ensures that other filters like Region are still respected.

Re: DAX Rank Function is not working when I choose multiple dates from the filter

Anonymous — Sat, 03 Aug 2024 13:42:34 GMT

Hi zenbabasha33
Source Data

Rank Function

Select any date from the slicer, the rank will adjust within itself

Re: DAX Rank Function is not working when I choose multiple dates from the filter

zenbabasha33 — Mon, 05 Aug 2024 14:12:55 GMT

Thank you