Forum Discussion

Snazzybecc's avatar
Snazzybecc
Frequent Visitor
3 years ago
Solved

Calculate % selected answer against total responses

Hi all, having a brain fog day

 

I have a checkbox, multipselect question 

 

If A selected I want to display the number of total rsponses for A as a percentage of the total responses. 

I'm just needing some direction for the structure of the measure 

 

Goal is table

Selecdted option / No responses / % of total responses 

 

thnaks

Sam

 

Need Help
  • Snazzybecc's avatar
    Snazzybecc
    3 years ago

    thanks all, with inspiration and some rest I came up with the below solution

    Measure =
    DIVIDE(
    COUNT(Table[Value]),
    CALCULATE(DISTINCTCOUNTTable[Start time]),
    ALL(Table)
    )
    )

    So in the below table this was a multi-select question with 113 responders and a total of 274 options selected 

    so for the top answer, 89 responders selected this option which is 78.8% of the total responders 

4 Replies

  • Snazzybecc's avatar
    Snazzybecc
    Frequent Visitor
    3 years ago

    HI, yes, see my example 

    I need to get a % for each row, i.e. 89/113, 74/113

    many thanks

    • Snazzybecc's avatar
      Snazzybecc
      Frequent Visitor
      3 years ago

      thanks all, with inspiration and some rest I came up with the below solution

      Measure =
      DIVIDE(
      COUNT(Table[Value]),
      CALCULATE(DISTINCTCOUNTTable[Start time]),
      ALL(Table)
      )
      )

      So in the below table this was a multi-select question with 113 responders and a total of 274 options selected 

      so for the top answer, 89 responders selected this option which is 78.8% of the total responders 

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Snazzybecc ,

    for percentage you can use the measure:

     

    DIVIDE( SUM(Table[Column]),
        CALCULATE(
                SUM(Table[Column]),
                 ALL(Table)
                 )
           )

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.