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
v-jiascu-msft Super Contributor
Super Contributor

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 406 members 3,434 guests
Please welcome our newest community members: