Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filtering survey data

Hi   I have a survey that I've been tasked to report on. The data is laid out as 1 row per question (question_text), with multiple rows referencing a single participant using a guid. And there are ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    1. Create two tables including Question and Answer column respectively. And there no relationship among the three tables.



    2. Create two slicer, one includes Question[Question], another one includes Answer[answer], then create a measure using the formula,

    question1 =
CALCULATE (
    FIRSTNONBLANK ( Table1[question], Table1[question] ),
    FILTER ( Table1, Table1[question] = SELECTEDVALUE ( Question[Question] ) )
)


    You will get expected result as follows.


    Please download the attachment(.pbix file) for further analysis.

     

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

1. Create two tables including Question and Answer column respectively. And there no relationship among the three tables.



2. Create two slicer, one includes Question[Question], another one includes Answer[answer], then create a measure using the formula,

question1 =
CALCULATE (
    FIRSTNONBLANK ( Table1[question], Table1[question] ),
    FILTER ( Table1, Table1[question] = SELECTEDVALUE ( Question[Question] ) )
)


You will get expected result as follows.


Please download the attachment(.pbix file) for further analysis.

 

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Where can I create a measure using the formula? on the visual level filters? I am very new to Power bI. Can you please share a screenshot where you used the formula? 

 

question1 =
CALCULATE (
    FIRSTNONBLANK ( Table1[question], Table1[question] ),
    FILTER ( Table1, Table1[question] = SELECTEDVALUE ( Question[Question] ) )
)