Forum Discussion

PHEstaciMa1's avatar
PHEstaciMa1
Icon for Helper II rankHelper II
11 months ago
Solved

Calculate Percentage from 2 different tables

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 coa...
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    11 months ago

    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's avatar
PHEstaciMa1
Icon for Helper II rankHelper II
11 months ago

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

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
11 months ago

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.