Forum Discussion

mmayer's avatar
mmayer
Frequent Visitor
7 years ago
Solved

Building Cross Tab with DropDown to Select Main Question

I have survey response data, organized by respondent (i.e. wide rather than tall data). That I have transformed with DAX into taller tables. With a column for all frequency questions, a column for all Frequency question answers, a column for all star rating questions, and a column for all star rating question answers. I am trying to us a Matrix to display a cross tab of the data that compares a frequency question to its relevant star rating answers,, with hopefully a drop-down option to select the initial primary frequency question, but outside of listing the categories of responses the matrix is blank no counts and no percentages show up. I have screen shots of what I have and what I am aiming for but do not see a way to attach.
  • mmayer's avatar
    mmayer
    7 years ago

    Hi Maggie, I was actually able to figure out building out the cross-tab.

     

    Thank you for your reply though!

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi mmayer

    When i try to reply this thread, i can see this icons on the top of the window, do you see these on your side?

    if so, you can use "photo" to upload pictures".

    Best Regards

    Maggie

    • mmayer's avatar
      mmayer
      Frequent Visitor

      Hi Maggie, I was actually able to figure out building out the cross-tab.

       

      Thank you for your reply though!