I have two tables set us as below:
• The Survey Set Id column references the table below & is the Key
• The “Yes Count”, “No Count” & “Maybe Count” columns reference the “Total Yes”, “Total No” & “Total Neutral” columns of the below table through the Reference column above
• The Survey Set Id column references the first table
• “Total Yes”, “Total No” & “Total Neutral” columns are virtual columns which count the total respective responses in the “Response” column – This is working correctly and totals are getting computed.
Problem is that the “Yes Count”, “No Count” & “Maybe Count” columns of the first table are showing blanks values.
I even tried a direct COUNT(SELECT(Survey.[Response], AND(_THIS ROW[Survey Set Up Id] = [Survey Set Up Id], [Response]= “Yes”))) in the “Yes Count column of the first table - that is without using the referencing route - and go the same result - blanks
Can anyone explain why this is so…
Other referenced columns in the 2nd table like the Survey Date are coming fine……