Percent of Column Total incorrect

[rgu101]

I'm calculating the response rate for this survey question by using Count (Distinct) for each survey ID. The counts (n-sizes) are correct but when I tried to show values as Percent of Column Total, the individual response rates are incorrect and thus don't add to 100%. I do have filters on, but when I double checked with the raw data, I can confirm the n-sizes are accurate.

Should I create a calculated measure to get an accurate number?

Thanks in advance.

[selimovd · Accepted solution]

Hey @rgu101 ,

why don't you just calculate it with DAX?

Percentage =
VAR _DistinctCount = [Your count measure]
VAR _Total = CALCULATE ( [Your count measure], ALL ( myTable[Column with agree disagree] ) )
RETURN
    DIVIDE ( _DistinctCount, _Total )

Then format as percent and you should be good to go.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
 

[rgu101]

Response Rate = 
VAR _DCount =
DISTINCTCOUNT('Raw Data'[Visit ID])

VAR _QTotal =
CALCULATE(
    DISTINCTCOUNT('Raw Data'[Visit ID]),
    ALLEXCEPT('Raw Data',
        'Raw Data'[QuestionText],
        'Raw Data'[Date],
        DateTable)
)

RETURN
DIVIDE(_DCount,_QTotal)

Thank you for the help. Settled with a calculated measure because i couldn't find any solutions for why the column total was incorrect.