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 this data in a Matrix with Columns as Category and Values as Value it can be seen below. What I would like however, is the Matrix to filter out the 0's that appear BUT only if Category C has a 0 and not if A or B has a 0. I guess I need some sort of measure to sort this as Advanced Filtering does not work (as filtering 0 removes all instances of 0 from values).
| A | B | C | |
| Row 1 | 10 | 30 | 0 |
| Row 2 | 0 | 0 | 20 |
Add it to the visual filters and set the value to 1.
