Forum Discussion

Betsy's avatar
Betsy
Helper IV
10 years ago
Solved

join calculated tables?

Hi,   I've created two calculated tables: One to summarize questions received by students (screenshot):     And one to summarize questions answered (screenshot):     In order to...
  • Betsy's avatar
    Betsy
    10 years ago

    I tried merging the question and responses tables first, as a couple people mentioned is probably best practice, but it wasn't coming out correctly, more rows than either original summarized calculated table, as if the merge was not filtering correctly. Stuff that people hadn't "received" was being marked as "responded" (I think non-questions, even with the filter I describe below) What finally worked:

     

    Merging comm type from communications table into the responses source table, and filtering on equals = question (I had already filtered out Package ID-less responses).

     

    Keeping the summarized tables, Questions Received and Questions Answered.

     

    Using the related function to create a column for Total Replied in the Questions Received table. Then calcuating the percent.

     

    Thanks everyone!!

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

Betsy

 

Not sure if you’re look for this. Since we have relationship between Questions Answered and Questions Received, we can use RELATED function.

Percent Replied = 
'Questions Answered'[Total Replied]
    / RELATED ( 'Questions Received'[Total Received] )

 

Best Regards,

Herbert

Betsy's avatar
Betsy
Helper IV
10 years ago

I tried merging the question and responses tables first, as a couple people mentioned is probably best practice, but it wasn't coming out correctly, more rows than either original summarized calculated table, as if the merge was not filtering correctly. Stuff that people hadn't "received" was being marked as "responded" (I think non-questions, even with the filter I describe below) What finally worked:

 

Merging comm type from communications table into the responses source table, and filtering on equals = question (I had already filtered out Package ID-less responses).

 

Keeping the summarized tables, Questions Received and Questions Answered.

 

Using the related function to create a column for Total Replied in the Questions Received table. Then calcuating the percent.

 

Thanks everyone!!