Forum Discussion

rgu101's avatar
rgu101
Icon for Helper I rankHelper I
2 years ago
Solved

Percent of Column Total incorrect

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, t...
Need Help
  • selimovd's avatar
    selimovd
    2 years ago

    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
     

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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's avatar
rgu101
Icon for Helper I rankHelper I
2 years ago
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.