Showing results for 
Search instead for 
Did you mean: 

Card with Percentage

I have a survey response which has the following columns:


Start date [shows the date the survey was submitted]

How did we do? [is a drop down list of 5 options; Excellent, Good, Okay, Unsatisfactory, Poor]


I want to create a card which shows the total percentages of positive responses [Excellent and Good].


Any help would be most appreciated.

Community Support Team
Community Support Team

Re: Card with Percentage

Hi @johnbradbury,


If you have the column of the list, you can add it in a slicer with drop-down type. If there isn't such a column, you can add a calculated column with the below formula.


Column =
IF (
    [score] >= 90,
    IF (
        [score] >= 80,
        IF ( [score] >= 70, "Okay", IF ( [score] >= 60, "Unsatistactory", "Poor" ) )

The percentage should be a measure.



Measure =
        COUNTROWS ( 'table' ),
        FILTER ( ALL ( 'table' ), 'table'[Column] IN { "Excellent", "Good" } )
    CALCULATE ( COUNTROWS ( 'table' ), ALL ( 'table' ) ),

If you'd like more precise formulas, please provide a dummy sample that we can download.




Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.