Forum Discussion
Create Measures based on Columns
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 cr...
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
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 |