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 has completed each Course/Training and the total number for the Department as shown is 2188 which is perfect!2. But when I select a certain Division from the filter, the number of completed adjust for each training/course, but the total number of employees is still showing the overall Department number instead of the Division which is 55 employees.
3. See the following illustrations in a chart:
4. As you can see, the first visual is correct showing the overall Department completion percentage, but when I filter to a certain Division, it is still showing the total for the Department instead of Division.
Please assist or recommend of how I can fix this issue. Thank you for your time.
Respectfully,
PRock
4 Replies
it is a little bit difficult to intepret the problem without checking the model , the relationships .
are you able to share the power bi file so i can take a closer look and help you out ?
best regards,
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]
