The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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
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.
HI, yes, see my example
I need to get a % for each row, i.e. 89/113, 74/113
many thanks
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |