DAX for cross table processing

[BrightMoon]

I have a Product Suite table like this (Suites/Edition/Product Code&Name),

And I have a 2nd table for people who has competency level for different products,

What I want to see is, for each edition of each suite, who have competency level greater than 3 for all the products, something like this,

Any hint will be appreciated.  Thank you!

[Anonymous · Accepted solution]

I'm assuming you have a many to 1 relationship on Product Name between your 2 tables?

Assuming so, you could create a new table with something like:
 
= FILTER (
      SUMMARIZE(Competency, Suites[Suite], Suites[ProductName], Competency[Name], "Competency Level", MAX(Competency[Level]),
      [Competency Level] > 3
   )

Though, I suspect you could skip the new table and just create a visual with appropriate filters, too.

[BrightMoon]

Thanks @Anonymous for your answer.