Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Maximum values across two tables

Hi all   I'm trying to find a maximum value for a particular ID across two tables but not having much success.  For example: Table 1 has many columns, including two: "ID" and "Score".  Any ID ca...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , not very clear. see if this measure can help

    MyAttempt = maxx(SUMMARIZE('Table1',Table1[ID],"Max1",MAX('Table1'[Score]),"Max2",MAX('Table2'[Max Score])),max([Max1],[Max2]))

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , not very clear. see if this measure can help

MyAttempt = maxx(SUMMARIZE('Table1',Table1[ID],"Max1",MAX('Table1'[Score]),"Max2",MAX('Table2'[Max Score])),max([Max1],[Max2]))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak 

 

I wasn't sure how to add it as a measure, but copy/pasting it into the definition of my table I received an error "The expression specified in the query is not a valid table expression".  I provided more details on my question as suggested by Greg.