Forum Discussion

Michalison's avatar
Michalison
Icon for Helper II rankHelper II
4 years ago
Solved

Calcuations

  I have this visual which is based on a teat sdlicer and Directorate slicer on an absence table - the calculation is Number of sick days divided by number of employees in the directorate  - when I ...
Need Help
  • Michalison's avatar
    Michalison
    4 years ago

    Thank you for your reply I have used your suggestion and its looking better but still not quite right 

     

    As you can see the absence FTE is now 70 when it should be 113 - I know what its doing its couting the FTE of those asbent from the resources department and not all people in the resources directorate I think the formula

     

    CALCULATE(distinctcount(Personnel_Records[Employee ID]), USERELATIONSHIP(Absence[Start Date], 'Absence Date'[Date]))

     

    perhaps the userelationship should not be based on the absence table I am not sure.   Many Thanks for your help

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You should have a Calendar Table.  Does this work?

Absence FTE = CALCULATE(SUM(Personnel_Records[FTE]), USERELATIONSHIP(Absence[Start Date], 'Calendar'[Date]))

Hope this helps?