How to apply filter on implicit measures in matrix Visual

[ykumar03]

This is my table.

table

and I have created this matrix visual on this

Now I want to apply a filter on this visual for records where C is blank and N has some count..Like below. Please help 

@PowerBI 

[AllisonKennedy · Accepted solution]

@ykumar03  Please paste your data in table format in future (can paste from Excel direct to this forum). It makes it much easier for us to help. 

One option is to use a measure in the matrix that does the filtering for you: 

Filter =

VAR _C = CALCULATE([Status Count], 'Table'[Status] = "C")

VAR _N = CALCULATE([Status Count], 'Table'[Status] = "N")

RETURN

CALCULATE([Status Count], FILTER(VALUES('Table'[empname]), ISBLANK(_C) && _N>0))

See attached sample file under my signature. 

[ykumar03]

Thank You so much @AllisonKennedy for your help.

[AllisonKennedy]

You're very welcome @ykumar03 Glad it worked for you. 🙂