Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Adding Dense rank

Hi guys,

Can anyone suggest a DAX to add a dense rank over a column and partition by two column. Below is my sample dax for single partition:

RANKX(FILTER(table,table[Date]=EARLIER(table[Date])),

table[Date_Time],,ASC,Dense)

I need to add one more partition.

Community Champion

Hi Anonymous
You may try

Ranking =
RANKX (
    CALCULATETABLE ( table, ALLEXCEPT ( table, table[Date], table[Column] ) ),
    table[Date_Time],
    ,
    ASC,
    DENSE
)