Forum Discussion
Filtering based on subitems
amrendra Aha, I see your dilemna now. Because you want to cross-filter across visuals, you have a filter on User and Course. There's not really a way to clear the filter on User only from the visual you click while still keeping the User filter from the visual you want updating. So, you can copy the User table, you your example we'll call it Employee Associated, and then use that in the second visual. Now we can clear the filter from Employee without clearing the filter from Employee Associated with a DAX Measure:
Result Associated =
CALCULATE( SUM( Training[Result ]), ALL(Employee))Relationships are very important here too:
Desired result:
See attached pbix below signature.
Hi AllisonKennedy , thank you for your reply. I do have dim for issues and authors.
It is similar to the example you shared and I used that data to create a quick example of what I am trying to do. I have two visuals on the page, one explaining the training data for users, while I have another visual related to the course view. I am looking at training data from user view and then decided to check who are all users also took that particular course.
I created a demo and exported the pbix file.
https://drive.google.com/uc?id=1eqowtCgZN7bme-DOyG3zy_wzDHbhuCCn&export=download
for example, I checked Mary and see that she has taken Excel Essential course, at that moment I would like to see who else has taken that course and right there clicked on the course. This triggers the filter for other visuals with (user + course) and it only shows me that for Mary. While I wanted to quickly check who all also took that course, and expected (desired) a filter to be triggered only for that course instead of combination with its parent.
You mentioned isolating the filter but I am unsure how I can achieve that. I am sure I am missing something.
Thank you for your help.
amrendra Aha, I see your dilemna now. Because you want to cross-filter across visuals, you have a filter on User and Course. There's not really a way to clear the filter on User only from the visual you click while still keeping the User filter from the visual you want updating. So, you can copy the User table, you your example we'll call it Employee Associated, and then use that in the second visual. Now we can clear the filter from Employee without clearing the filter from Employee Associated with a DAX Measure:
Relationships are very important here too:
Desired result:
See attached pbix below signature.