Forum Discussion
Solved
Filter 0 from One Matrix Column Only
Hey, I have a Matrix table with Values which appear in 3 categories (Table example below): Category Value A 10 A 0 B 0 C 0 B 30 C 20 When displaying...
Add it to the visual filters and set the value to 1.
TotunG , you can use this measure for filtering:
Measure = IF(SELECTEDVALUE(Table[Category]) = "C" && SELECTEDVALUE(Table[Value]) = 0, 0, 1)Set it equal to 1 in the matrix visual filters.
Nice - thank you. I get this can be used as a sort of indicator now. But I'm still struggling to get this to filter out Category C 0 values only? Do you know the next steps to this?
