Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Looking up Multiple values

I have 3 tables as shown above, I have a 1-Many relationship between Table2 and Table 1, another 1-Many relationship between Table2 and Table 3 I want to create a tabular visual in power b...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    is this what you want?

     

    Measure = CALCULATE(max(Table2[Customer Name]),FILTER(Table2,Table2[ID]=MAX(Table1[ID])))

     

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

is this what you want?

 

Measure = CALCULATE(max(Table2[Customer Name]),FILTER(Table2,Table2[ID]=MAX(Table1[ID])))