Forum Discussion

gaznez's avatar
gaznez
Resolver I
2 years ago
Solved

Dynamic ranking

Hi all,   I have a matrix with dates as the rows, branch as the columns, and then sales volumes and a rank as the values. The measure for my rank is:   RankVolOM = RANKX(ALL(Dates[Date]), [Total...
Need Help
  • gaznez's avatar
    gaznez
    2 years ago

    UPDATE: I managed to figure this out if anyone is interested (with the help of ChatGPT)
    The following formula works (I'm not sure why/how)

    RankVolOM = VAR AllSelectedDates = CALCULATETABLE(
        VALUES(Dates[Date]),
        ALLSELECTED(Dates)
    )
    RETURN
    RANKX(
        AllSelectedDates,
        [TotalVolOM],
        ,
        DESC,
        Dense)
PabloVallejo12's avatar
PabloVallejo12
Helper I
2 years ago

Try to create a normal measure without rankx, and add a filter on the visual whit that requirement , like that :

 

gaznez's avatar
gaznez
Resolver I
2 years ago

Hi PabloVallejo12 ,  thanks for the suggestion.  However - I don't want to show the top N values.  I may want to select 2 years and see the ranking for all volumes in that date range.

Also when I click on filters - my only options are things like 'is less than', 'is greater than', 'is not' etc.  There are no options for 'Top N'.