Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Multiple Tables

Hi All, Assume a table as follows. Table 1 Table 2                       I need output considering following steps:   1) Select ID from Table 2 where R1=MAX(R1) 2) Out...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Try like

measure =
var _max =maxx(Table2,Table2[R1])
return
calculate(countrows(Table2),filter(Table2,Table2[R1] =_max))

 

measure =
var _max =maxx(Table2,Table2[R2])
return
calculate(countrows(Table2),filter(Table2,Table2[R2] =_max))

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak 

    The mentioned measure would return me the Count of Rows .

    I need to get the exact ID from Table 2 which has highest combination i.e. R1=10 and R2=10.
    The measure for CountRow returns the no of rows.

     

    Regards

    Ayush