Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Snazzybecc
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

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 

2210Solution.png

View solution in original post

4 REPLIES 4
mangaus1111
Solution Sage
Solution Sage

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.

Snazzybecc
Frequent Visitor

HI, yes, see my example 

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

many thanks

powerbiq.png

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 

2210Solution.png

mangaus1111
Solution Sage
Solution Sage

HI @Snazzybecc ,

can you share a sample table ?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors