Forum Discussion

Helper III

2 years ago

Solved

Solution Requested

Hello Everyone, I have a complex requirment which i am unable to resolve. Basicall i have 3 data set which is from 3 different source (Tables) Source 1) Employee Id along with their Job Level ...

2 years ago

shantupm5

Please check the attached file.

Completion Rate = 
VAR __EmpJob = COUNT( EmpJob[Emp Id] )
VAR __EmpCount = COUNT( EmpJobModule[Emp Id])
RETURN
    DIVIDE(__EmpCount,__EmpJob)

Solution Requested.pbix29 KB

shantupm5

Helper III

2 years ago

Hello Ashish,

Unfortunelty i will not be able to upload the PBIX due to security reasons.

so to illisturate below is the output we need from above table

For Example : For Job Leve 3, we have 9 employees.

So each employee should complete all the mandatory trainings

But for Foundation - 3, only 5 have completed out of 9 employees. which will be 55.6% as mentioned below.

JL	2	3	4
Foundation - 2	100%
Intermediate - 2	67.00%
Pro - 2	33.33%
Foundation - 3		55.60%
Intermediate - 3		44.40%
Pro - 3		22.20%
Foundation - 4			67.00%
Intermediate - 4			33.33%
Pro - 4