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]) )

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
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.