More than one filter in RANKX

[Anonymous]

Hi,

Need help in adding 2 filters in RANKX and sorting by Date.

Column = RANKX (
FILTER (Table1, Table1[Topic] = EARLIER ( Table1[Topic] ) ), FILTER (Table1, Table1[ID] = EARLIER ( Table1[ID] ) )
Table1[Date].[Date],
ASC,DENSE
)

However , I get an error - he expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Any way to fix this?

Thanks

Shirin

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous 

To combine multiple filter conditions we can use && or || operators

Column =
RANKX (
    FILTER (
        Table1,
        Table1[Topic] = EARLIER ( Table1[Topic] )
            && [ID] = EARLIER ( Table1[ID] )
    ),
    Table1[Date].[Date],
    ,
    ASC,
    DENSE
)

[pfinanciero]

Hi @Zubair_Muhammad 
Excuse me, any idea of transform this formula in a measure?