Lookup max value from two different tables with many to many relationship

[dirkkoch]

Hi, 

I am trying to combine data from two different tables with a many to many relationship and get the max value as well as the sum of ID's for a set of distinct values.  A sample with the desired result can be shown in the screenshot below. 

Looking forward to any helpful support!

[v-yanjiang-msft]

Hi @dirkkoch ,

Has your problem been solved? If not, would you like to attach your pbix file here without sensitive data? It's hard to reproduce the relationship of the two tables.

Best Regards,
Community Support Team _ kalyj

[amitchandak · Accepted solution]

@dirkkoch , On of the way is create common tables and join with both of them and avoid many to many

example

Numer_id= distinct(union(distinct(Table1[Numer_id]),distinct(Table2[Numer_id])))

You create one or more such tables and analyze data with help of those

https://www.seerinteractive.com/blog/join-many-many-power-bi/

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.