Forum Discussion

zenbabasha33's avatar
zenbabasha33
Regular Visitor
2 years ago
Solved

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

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. Ra...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi zenbabasha33 
    Source Data

    Rank Function

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

aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

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
)

 

zenbabasha33's avatar
zenbabasha33
Regular Visitor
2 years ago

Thank you but I alreaddy  Tried this one