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

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

Michalison , it should be the distinct count of employee id ?

like 

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

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

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

Thanks that worked