Filter 0 from One Matrix Column Only

[TotunG]

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

[ERD]

@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.

[TotunG]

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?

[ERD · Accepted solution]

Add it to the visual filters and set the value to 1.

[TotunG]

Appreciate the help, although it still doesn't work. I'll give you kudos tho.