summary table
1 Topic
Cant use a var in count and looking for help,
Hi, I am trying to count the number of entries in a survey based on the question Value eg Question 1 Summary Table Department Question Count Responses Count Agreed Department A Question 1 3 2 Department B Question 1 3 0 Department A Question 2 3 2 RawData Table ID Department Q1 Q2 Q3 1 Department A Agree Agree Agree 2 Department b Disagree Agree Disagree 3 Department A Agree Agree Disagree I have tried using variables and count but i get an error that says i need to use a column reference. Count Responses = VAR Field = "'RawData'[" & Transformation[Question] & "]" VAR RowCount = CALCULATE(COUNT(Field)) RETURN RowCount Any pointers would be really appreciated.Solved1.8KViews0likes8Comments