Calculate Percentage from 2 different tables

[PHEstaciMa1]

hi all, I'm trying to calculate weekly compliance percentage of each department for every week coaching session versus the number of personnel present on a particular week. However, the number of coaching session and attendance of personnel is from two (2) different tables.

Example. 

Table 1 HR Wk10 # of Coaching Session - 2

Table 2 HR Wk10 # of Personnel Present - 3

Compliance Wk10 = 67%

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Compliance %: = 
DIVIDE( SUM(coaching_session[session]), SUM(personnel_present[present]) )

[PHEstaciMa1]

thanks jihwan, it worked... I somehow got the relationship wrong

[v-sgandrathi]

Hi @PHEstaciMa1,

Thank you for confirming, and we’re glad to hear that the solution provided by @Jihwan_Kim worked for you. Thank you so much for your answer.
The issue was indeed related to the relationship setup in your model, and once corrected, the calculation returned the expected results.

If you encounter any further challenges, please feel free to open a new discussion in the forum.
Thank  you.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Show the problem there clearly.