Forum Discussion
Impactful Individualrelationship and filtering two tables with multiple variables
hello community,
i have a table 1 with TYP and SEGMENT and for every TYP existing one SEGMENT. In Table 2 (this will be a table with comments) there are existing more TYP and SEGMENT in a row:
simplified picture:
Question: When Table 1 is filtered I want to see the choosed komibinations in table 2. for example if X and Y and B and C is filtered i want to see the fourth row in table 2. Is that possible or to complicated to implement?
thanks for ideas.
HI Pikachu-Power,
AFAIK, the default filter effect does not support these effects. I'd like to suggest you broke the table relationship and write a measure formula to extract the selected value and compare it with the current value to use on the 'visual level filter' to achieve your requirement.
SELECTEDVALUE function - DAX | Microsoft Docs
SEARCH function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
3 Replies
- amitchandak
Super User
Pikachu-Power , My advice would be split table 2 by delimiters in power query, if possible
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
Pikachu-PowerOkay but what could be the next step? The difficulty is that in table 1 there could be two or more selections. With one selection it would be possible by using containsstring.
HI Pikachu-Power,
AFAIK, the default filter effect does not support these effects. I'd like to suggest you broke the table relationship and write a measure formula to extract the selected value and compare it with the current value to use on the 'visual level filter' to achieve your requirement.
SELECTEDVALUE function - DAX | Microsoft Docs
SEARCH function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
