Forum Discussion

qwertzuiop's avatar
qwertzuiop
Advocate III
2 years ago
Solved

Group by ID

Hello dear Power BI Community   I have the following problem to solve - let's assume this situation: Participants in a questionnaire give various answers to diffrent questions. They can answer th...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    qwertzuiop ,

    Please see attached pbix.

    Solution involves creating one Calculated Column.

    Then creating your Table (or other) visual.

    Hope this works for your larger dataset.  Let me know if you have any questions.

    Regards,

KNP's avatar
KNP
Super User
2 years ago

This measure may do the trick but depends on your actual data...

Questions Answered = 
    CALCULATE(
        DISTINCTCOUNTNOBLANK(Questions[Question]), 
        Questions[Question answered?] = "X"
    )