cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Percentage of Total using Yes and No values

Billy                             Terminology                          Yes

Billy                                Iron                                     No

BIlly                                Iron                                     No

Billy                                Valves                                  Yes

Billy                                Valves                                  Yes

Here is a small sample of a large database i have.  I am trying to breakdown the percentage correct of each individual engineers answers on the test.  Then be able to look at the engieers as a whole and see where they are missing the most questions. So for example on this set i can see he missed 100% of the Iron questions.  Also i can see that he missed 3 out of 5 questions on the test. I am looking for an effective way to plot and visually see this prefferably through a horizontal bar graph

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

@Jstitch

In this scenario, you can create percentage of total measures group on corresponding column and put into a chart visual.

```Answered of Total =
CALCULATE (
COUNTA ( Table[Questions] ),
FILTER ( Table, Table[Answered] = "Yes" ),
ALLEXCEPT ( Table, Table[Engineer] )
)```

```Answered of Total per Category =
CALCULATE (
COUNTA ( Table[Questions] ),
FILTER ( Table, Table[Answered] = "Yes" ),
ALLEXCEPT ( Table, Table[Engineer], Table[Category] )
)```

Regards,

2 REPLIES 2
Highlighted
Microsoft

@Jstitch

In this scenario, you can create percentage of total measures group on corresponding column and put into a chart visual.

```Answered of Total =
CALCULATE (
COUNTA ( Table[Questions] ),
FILTER ( Table, Table[Answered] = "Yes" ),
ALLEXCEPT ( Table, Table[Engineer] )
)```

```Answered of Total per Category =
CALCULATE (
COUNTA ( Table[Questions] ),
FILTER ( Table, Table[Answered] = "Yes" ),
ALLEXCEPT ( Table, Table[Engineer], Table[Category] )
)```

Regards,

Highlighted
Regular Visitor

This is perfect!!!!! This is exactly what i needed thank you so much for your help!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors