cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Percentage of Total using Yes and No values

 

Engineer Name             Category                    Answered Correctly

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
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,

View solution in original post

2 REPLIES 2
Highlighted
Microsoft
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,

View solution in original post

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors