Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to calculate employee sickness absence rate, the end goal is to have a graph showing the absence rate for each month which will change when a different business area is selected. The calulcation will be Total Sickness Days Lost / Available Working Days (Sum of FTE X Working Days for the month)
I've started out with 4 tables.
These are the relationships I have set up and I've created a table with what I'm hoping to achieve. When I change the DB Super Sector, it changes the FTE but not the total no of days sickness. I'm sure it's a simple fix but I can't work it out.
A couple of things I noticed:
Proud to be a Super User!
I'm afraid I'm unable to share the file due to the sensitivity of the data.
1. Would that be one directional from Employee Info to Working days?
2. What would I change it to?
3. What type of relationship would this be? Would this then filter all of the other matching columns?
Proud to be a Super User!
okay how do you calculated your measures?
Is it possible for you to share your pbix?
Thanks for the quick reply, the table in the slider is "Sector"
Hi
Which table are you using in the slider? Because you have that column in two tables.
If you are using the Sector table notice that you don't have an active relationship.
Please also provide you DAX measure.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |