Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Card visual help

I have a survey data that has 5 different responses, I want to show the percentage of two fields compared to the total 5 fields.    Very satisfied, satisfied, neutral, dissatisfied, very dissatisfi...
  • VahidDM's avatar
    VahidDM
    4 years ago

    Hi Anonymous 

     

    Try this:

    Satisfication with Provider = 
VAR _SVS =
    CALCULATE (
        CountA('Qualtrics Survey sample data'[Satisfaction with provider]),
        FILTER (
            ALL ( 'Qualtrics Survey sample data' ),
            'Qualtrics Survey sample data'[Satisfaction with provider] = "Satisfied"
                || 'Qualtrics Survey sample data'[Satisfaction with provider] = "Very satisfied"
        )
    )
VAR _AO =
    CALCULATE (
        CountA('Qualtrics Survey sample data'[Satisfaction with provider]),
        ALL ( 'Qualtrics Survey sample data' )
    )
RETURN
    _SVS/_AO

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

what am I doing wrong here? VahidDM 

VahidDM's avatar
VahidDM
Super User
4 years ago

Anonymous 

 

Just change the red text with column name between [  ] and then ="...".

 

Copy and paste the measure here as a text not image then I will update that.

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/