Creating Column Chart, Counting If Yes,

[patri0t82]

Hi, I'm very new to Power BI. I've tried searching for this answer, but am only seeing similar questions, but not quite exact.

I would like to create a bar/column chart. The Horizontal Axis contains Shifts (A, B, C, D, Days, Other Shift). There are four columns for which the values are counted from. (Behavioural, Hazard, Risk, Near Miss). I need the chart to show me a count of the word "Yes" from each of the four columns, however, I can only seem to apply "Yes" to one at a time. In the example below, it's only showing the total combined "Yes", "No" and blanks.

[jthomson]

What exactly are you feeding into the visual? Are you putting in a measure that has something like BehaviouralCount = calculate(countrows[yourtable],Behavioural="Yes"), or something else?

[patri0t82]

I think that's just it, I don't know what I'm doing 😞 I've just created the chart and dragged my columns into it. I'm trying to adjust the filters, but I'm thinking I need to use measures?

[jthomson · Accepted solution]

Yeah, I guess that the default action of Power BI would just be to count all. If you make a measure similar to what I wrote in my previous post for each of your four columns, it should work as they'll only consider rows where the relevant column contains yes.

[patri0t82]

Ahh, I tried this and it seems to be working

HazardCount = calculate(countrows(SafetyLink),SafetyLink[Did you complete a Hazard Elimination]="Yes")

Thanks so much!

[patri0t82]

I really appreciate your help - would you be able to explain the syntax of your formula a bit? Which part is the Exact column header, etc.?