Forum Discussion
calculated measure
You have to use DAX to achieve this.
This is assuming you have either 'Yes' or 'No' in the [Course Completed], [Completed Late] and [Past Due] columns. If not, you can edit the measures to fit what you have in your data set.
Add a card visual to your report. Then set the 'Values' field to the measure that counts the employees who completed on time.
1. Employees Completed On Time = COUNTROWS(FILTER(TableName, TableName[Completed On Time] = "Yes"))
2. Employees Completed Late = COUNTROWS(FILTER(TableName, TableName[Completed Late] = "Yes"))
3. Employees Not Complete and Past Due = COUNTROWS(FILTER(TableName, ISBLANK(TableName[Completion Date]) && TODAY() > [Due Date]))
4. Employees Not Complete and Not Past Due = COUNTROWS(FILTER(TableName, ISBLANK(TableName[Completion Date]) && TODAY() <= [Due Date]))
Let me know if this works.