Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank if

Could someone give me the M code or DAX formula to achieve the result in column Rank? Many thanks!   Type       Date             Rank Type A    01/01/17     1 Type A    01/02/17     2 Type A    ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    As a calculated column..you can use

     

    Column =
RANKX (
    FILTER ( Primary_ID, [Type] = EARLIER ( [Type] ) ),
    [Date],
    ,
    ASC,
    DENSE
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks.

 

I've tried this..

 

=CALCULATE(RANK.EQ(Primary_ID[Date],Primary_ID[Date],ASC),FILTER(all(Primary_ID),Primary_ID[Type]=Primary_ID[Type]))

 

But get the error..

 

A single value for column 'Date' in table 'Primary_ID' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

themistoklis's avatar
themistoklis
Community Champion
7 years ago

Anonymous

 

You have to declare the variables outside the DAX formula and then call them inside (as shown on the formula sent). 

They are immutabe that's why i used them.

 

If you try it as shown, you will see it works this way