Create Measures based on Columns

[Anonymous]

Hi,

I have 2 tables.

Table1

Question

1

2

Table2

ID	Question 1	Question 2
1	Strongly Agree	Agree
2	Agree	Agree
3	Agree	Neutral

I would like to create a measure in Table2 called RESPONSE. If I choose 1 in Table1 then RESPONSE will have the same result in Question 1; and if I choose 2 in Table2 then RESPONSE will have the same result in Question2.

Thank you for the assistance.

[d_gosbell · Accepted solution]

That would be tricky with the data in it's current form and would get harder and harder to maintain as you add more questions.

However if you unpivot Table 2 so that it looks like the following you can then create a simple rowcount measure and create charts and visuals off that.

ID	Question	Response
1	1	Strongly Agree
2	1	Agree
3	1	Agree
1	2	Agree
2	2	Agree
3	2	Neutral