Forum Discussion

edzkulasa's avatar
edzkulasa
New Member
4 years ago
Solved

Survey Responses

Hello All   I am trying to create a Card Visualization that will only shows the percentage of 'Happy & Neutral' responses out of total survey questions responses.   The table data as shows below ...
Tips and Tricks
  • johnt75's avatar
    johnt75
    4 years ago
    Happy & Neutral % =
    var totalResponses = COUNTROWS( 'Responses' )
    var happyNeutralResponses = CALCULATE( COUNTROWS( 'Responses' ), TREATAS( { "Happy", "Neutral" }, 'Responses'[Rating] ) )
    return DIVIDE( happyNeutralResponses, totalResponses )
johnt75's avatar
johnt75
Super User
4 years ago
Happy & Neutral % =
var totalResponses = COUNTROWS( 'Responses' )
var happyNeutralResponses = CALCULATE( COUNTROWS( 'Responses' ), TREATAS( { "Happy", "Neutral" }, 'Responses'[Rating] ) )
return DIVIDE( happyNeutralResponses, totalResponses )
  • edzkulasa's avatar
    edzkulasa
    New Member
    4 years ago

    Thanks johnt75 . It works 😉