Count blanks in a matrix

Question

Hi Folks,&nbsp;I have the below matrix visual:I used blue to just block out names. The red is a conditional to identify blanks.&nbsp;I am using three fields:&nbsp;&nbsp; Manager Name as the ROW&nbsp; Employee Type as the COLUMNS (Two values - Employee or Contingent Worker)&nbsp; Employee Number as the VALUES and using the COUNT option not COUNT DISTINCT.&nbsp;&nbsp;&nbsp;This gives me how many employees and contingent workers each manager has.&nbsp;&nbsp;What I want to do is COUNT how many blanks are in the EMPLOYEE column. I don't care about the Contingent Worker column.&nbsp;Is this possible? If so, how do I do it. I'm rather stuck.&nbsp;&nbsp;Many thanks!&nbsp;&nbsp;

zubair_muhammad · Accepted Answer

Hi Anonymous&nbsp;Try this MEASURE&nbsp;Count =
VAR Temp =
    FILTER (
        SUMMARIZE (
            Table1,
            Table1[Manager Name &amp; ID],
            "Count", CALCULATE (
                COUNT ( Table1[Employee Number] ),
                Table1[Employee Type] = "Employee"
            )
        ),
        [Count] = 0
    )
RETURN
    COUNTROWS ( Temp )&nbsp;

Forum Discussion

Count blanks in a matrix

2 Replies