Forum Discussion
Conditional filtering based on existing conditions
I have a table (table1) in a matrix visual that is linked to a second table (table2). Table2 has a category column (x) where each row is labelled as either 1 or 0. I want a separate visual (...
Hi BeardedDog888 ,
Here are the steps you can follow：
1. Create calculated table.
Company =
DISTINCT('Table'[Company])
2. Create measure.
Flag =
IF(COUNTROWS(ALL('Table'))=COUNTROWS(ALLSELECTED('Table')),0,1)3. Place [Flag] in the Filter of the Company Table to 1.
4. Place the [Company] of the Table in the Filters on this page.
5. Result:
When there are 1 and 0, it is not displayed
When there is only 1, display all
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Unfortunately this doesn't solve the issue as I still need to display visual when both 0 and 1 values are in the table, it is just that when this occurs only 0 values should show in the visual.