Percentage of Total using Yes and No values

[Jstitch]

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

[newpowerbiuser8]

Hello! 

I want to calculate distinct values of column A. Which i did by using the distinct function in a measure I created. 

Now I want to calculate the total number of "No" for each unique value only. Can anyone please help? @v-sihou-msft 

For example the total should be 3 for "No" as I want to count for Saturday as only 1 not 2 times. 

[v-sihou-msft · Accepted solution]

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

[Jstitch]

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