cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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.

1 REPLY 1
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,
    "Excellent",
    IF (
        [score] >= 80,
        "Good",
        IF ( [score] >= 70, "Okay", IF ( [score] >= 60, "Unsatistactory", "Poor" ) )
    )
)

The percentage should be a measure.

 

 

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

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

 

 

 

Best Regards,
Dale

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.