Forum Discussion

shantupm5's avatar
shantupm5
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 ...
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    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)

     



Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Based on the 3 tables that you have shared, show the expected result very clearly in a Table format.  Still better would be share the download link of the PBI file with 4 tabs - one each for the Tables that yo have shared in your original post and the last one showing the expected result.

  • shantupm5's avatar
    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. 

     

    JL234
    Foundation - 2100%  
    Intermediate - 267.00%  
    Pro - 233.33%  
    Foundation - 3 55.60% 
    Intermediate - 3 44.40% 
    Pro - 3 22.20% 
    Foundation - 4  67.00%
    Intermediate - 4  33.33%
    Pro - 4