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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-diye-msft ,

I agree with your point.
Please consider thew below scenario.
For ID 1,2,8 I need the following output too. (Measure 3 needs to be modified)

In Measure 3 value I need Output as (Id=2) because (my requirement) ,  For Max value in R1 , first I need all values in R2. (Like a nested filter)
1) Table2 (MAX)R1=10, thus we have ID= (1,2,8)

2)  For ID=(1,2,8) in table2 we need to find all R2.


3) Thus, R2=(9,10,9) for R1=(1,2,8) respectively.       <---------// Sets


4) Now, Measure 3 shall return me all ID of Table 2 where R2 is maximum from above selected set not the orignal table.
    Means Measure 3 shall be equal to Id=2 as we have (R1=10,R2=10) which is maximum combination out of the sets .

5) Then Measure 4 shall give me Final title =I   (as Table1.ID=TAble2.ID=2)

Really appreciate your time .

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey v-diye-msft 

    thanks for the help here. 

    This is what i somewhat needed, will have to implement this on a larger scale now.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-diye-msft 

    I believe I have one more case here:


    If I have multiple values in Table 1 where combination of R1 and R2 is max ,then i need - 
    Measure 4 values as H,I currently it will only show I as we have taken maxx.

    I just need Output of Measure 4 as H,I now as we have 2 rows where the combination is maximum instead of 1 previously.

    Thanks in advance.