Response rate measure

[ChristianAU]

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.

[Arul · Accepted solution]

@ChristianAU ,

Please refer the attached file.

[ChristianAU]

Thank you, it worked!

[_AAndrade]

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: