Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate No response

Dear all, I want to extract list of employees who dont fill out the response form. Available data: 1. I have list of total employees. 2. Response from employees who fill on daily basis. Issue: ...
Need Help
Show and Tell
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

First, make sure you have relationships between tables

Second, add a measure into Employee table

Measure = 
var _maxDays = CALCULATE(DISTINCTCOUNT(ResponseTable[Date]), ALL(ResponseTable))
RETURN
IF(DISTINCTCOUNT(ResponseTable[Date]) < _maxDays, FALSE(), TRUE())

Third, filter by FALSE() value of new Measure - it will match your demand