Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

More than one filter in RANKX

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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    6 years ago

    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
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
6 years ago

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's avatar
pfinanciero
Frequent Visitor
4 years ago

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