Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create Measures based on Columns

Hi,

 

I have 2 tables.

 

Table1

Question
1

2

 

Table2

IDQuestion 1Question 2
1Strongly AgreeAgree
2AgreeAgree
3AgreeNeutral

 

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.

Need Help
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    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

     

1 Reply

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago

    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