Forum Discussion
All with filter
Hi Tommyvhod ,
Based on your requirements description, I can probably see what you mean, you want to implement the requirement for "not to filter the category by the visual and filter out only the A category", based on my experience and testing, if you don't want to filter the category by the visual, you can try using "Edit" in Power BI desktop interaction" feature to turn on or off the interaction of one visual with other visuals.
Change how visuals interact in a report - Power BI | Microsoft Learn
For your other idea of "filter out only the A category", I think you can try to use the AllExcept() function in DAX to create a measure or calculate a column, and it can achieve the effect of removing all context filters in the table except filters that have been applied to the specified columns:
ALLEXCEPT function (DAX) - DAX | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
I need to filter the data with the visual filter as well. I created a new column with the same data but for the corect defect category. Should be filtered with same dimensional filter. The problem is, if I filter the category, hides all other categories and defects where A category is responsible is not showing. ( like row 3 in table above category B defect responsible category A) Or if I am adding ALL than it is not counting only the A defect responsibles but also the category / responsible category matches. ( like row 4 C/C ).
I want to keep all the rows for the category and count only the visually filtered categorie responsible and not the matches .