Forum Discussion

wdvro's avatar
wdvro
Frequent Visitor
2 years ago
Solved

Visualisation multiple choice answers

Hello,   I took a survey where some questions allowed respondents to tick multiple response options. In my report, I would have liked to show the proportion of respondents who ticked a particular a...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    Hi wdvro 

     

    You need to first find out how respondants there are. Presuming there is a ResponseID or UserID in the Data ?

    Reposnses/Users = DISTINCTCOUNT('Table'[ResponseID])

     

    Then Create this

     

    % = DIVIDE([Responses/Users], CALCULATE([Responses/Users], ALL('Table')))

     

    Convert to %

     

     

     

    Thanks

    Joe

     

    If this post helps, then please Accept it as the solution

JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Hi wdvro 

 

You need to first find out how respondants there are. Presuming there is a ResponseID or UserID in the Data ?

Reposnses/Users = DISTINCTCOUNT('Table'[ResponseID])

 

Then Create this

 

% = DIVIDE([Responses/Users], CALCULATE([Responses/Users], ALL('Table')))

 

Convert to %

 

 

 

Thanks

Joe

 

If this post helps, then please Accept it as the solution

  • wdvro's avatar
    wdvro
    Frequent Visitor
    2 years ago

    Thank you, just what I was looking for!