Forum Discussion

BrightMoon's avatar
BrightMoon
Regular Visitor
9 years ago
Solved

DAX for cross table processing

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 ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    BrightMoon
    Regular Visitor
    9 years ago

    Thanks Anonymous for your answer.