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