Calculating Performance Percentage from 2 Tables with condition

[PHEstaciMa1]

Hi Everyone, I need help in creating a performance compliance percentage table from 2 different tables. Data Table Input 1 is the actual performance of employee who created a tag on a monthly basis. Data Table Input 2 is the Target Tag Creation per Employee per Month. 

The expected output table should provide me compliance percentage per month. Now, there is a condition here, the target tag creation per employee per month is only 1 Tag per Month per Employee, regardless if the employee created 2,3,4, and so on, it will only count as "1".  I have attached an excel file for better understanding and data manipulation. Google Drive 

@Jihwan_Kim 

[v-achippa]

Hi @PHEstaciMa1,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ashish_Mathur and @danextian for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @PHEstaciMa1,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @PHEstaciMa1,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[danextian · Accepted solution]

Hi @PHEstaciMa1 

Your tables have to be unpivoted and you'll need to create dimension tables to connect the two fact tables. 

Please see the attached pbix. 

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.