Group max related value from another table

[lanluokaka]

I have 2 tables, one just has ids, and the other one has those id usages. I want find the most used SDK within certain days. How do I make a measure to still keep the time slicer? And find the max usage-related SDK value in table 1.

[lanluokaka]

Thanks, Greg! I just found it after I add some values from another table. It gives me all repeat measure results for one id. 

[lanluokaka]

@Greg_Deckler single row was expected. Now it has multiple repeated rows. Do you have suggestions?

This is the screenshot before the measure.

[Greg_Deckler]

@lanluokaka Are you missing a relationship?

[lanluokaka]

I do have a relationship, it's based on the id.

[Greg_Deckler]

@lanluokaka So, what do you want to happen? Which row should display?

[lanluokaka]

Thank you so much! It works, why does it need the max id in the first var?

[Greg_Deckler]

@lanluokaka Just a way of not having to use EARLIER

[Greg_Deckler · Accepted solution]

@lanluokaka Seems like Lookup Min/Max: Lookup Min/Max - Microsoft Power BI Community. In your case:

Measure = 
  VAR __ID = MAX('table 1'[id])
  VAR __MostUsage = MAXX(FILTER('table 2',[id]=__ID),[usage])
RETURN
  MAXX(FILTER('table 2',[id] = __ID && [usage]=__MostUsage),[sdk])