Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a column with 1's and 0's which is based on a yes/no system, where 1's = yes and the 0's = no.
How do i make a measure that gives me a response rate with this dataset? The percentage of the dataset with 1's compared to 0's.
Solved! Go to Solution.
Please refer the attached file.
Please refer the attached file.
Thank you, it worked!
Hi @ChristianAU,
Here is my solution:
I'm using this table:
I have 3 "YES" at a total of 8 answers, so 37.5% of YES answers.
I used this DAX measure to compute this number:
% YES =
VAR _CountYes =
CALCULATE(
COUNT(T_Responses[Answer]),
T_Responses[Answer] = 1
)
VAR _TotalAnswers = COUNTROWS(T_Responses)
VAR _Result = DIVIDE(_CountYes, _TotalAnswers)
RETURN
_Result
Final result:
Proud to be a Super User!
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |