title: DAX - count attributes for which FACT records do not exist
body: <p>I am looking for a DAX measure that is equal to If i have in SQL:</p>
  
  <pre><code>SELECT COUNT(NoDataValue WHEN -1 THEN 1 ELSE 0 END)
  FROM
  (
  SELECT Employee.EmployeeID, CASE WHEN FACT.EmployeeID IS NULL
                              THEN -1 
                              ELSE 1
                              END as NoDataValue
  FROM Employee LEFT OUTER JOIN FACT
  On Employee.EmployeeID = FACT.EmployeeID
  ) X 
  </code></pre>
  
  <p>Essentially i want -1 when there is no data for an employee at the row level but when its aggregated i need count of NoDataValues (How many employees did not have data).
  That is working fine at employee level with the measure i created</p>
  
  <pre><code>Annual Independence Compliance No Data:=
    Var NoData=
    SUM ( [NoDataValue] )
  RETURN (IF (ISBLANK(NoData) , -1, NoData))
  </code></pre>
  
  <p>This looks like</p>
  
  <p><a href="https://i.stack.imgur.com/nijvt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nijvt.png" alt="enter image description here"></a>
  But this is not aggregating the counts. I am having trouble of how to do that. This shows up as</p>
  
  <p><a href="https://i.stack.imgur.com/tqGMX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tqGMX.png" alt="enter image description here"></a></p>