Forum Discussion
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 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!
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.
2 Replies
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.Thanks Anonymous for your answer.
