Forum Discussion
Need Assistance Troubleshooting Filter Issues
Hello everyone, I need assistance with either the DAX I am using, data relationship when filtering. Please see the following: 1. This illustration shows the overall number of employees that h...
Can you share the DAX for the three measures you have used?
I am thinking out loud, that you might have used ALL.
Thank you sevenhills. Please see the following DAX:
1. Training Actual Completed Per Employee = COUNTROWS('TRAINING DATA')
2. Training Total Not Completed For Activity =
var TotalEmp = ALLSELECTED('TRAINING DATA SUPP'[Total Count of Employee Column])
var EmpComplete = [Training Actual Completed Per Employee]
RETURN
TotalEmp - EmpComplete
3. Training Completed + Not Completed =
[Training Actual Completed Per Employee] + [Training Total Not Completed For Activity]