Forum Discussion

ykumar03's avatar
ykumar03
Frequent Visitor
5 years ago
Solved

How to apply filter on implicit measures in matrix Visual

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 

Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    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. 

3 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    5 years ago

    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.