Forum Discussion

patri0t82's avatar
patri0t82
Post Patron
8 years ago
Solved

Creating Column Chart, Counting If Yes,

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 conta...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    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's avatar
patri0t82
Post Patron
8 years ago

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's avatar
jthomson
Solution Sage
8 years ago

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's avatar
    patri0t82
    Post Patron
    8 years ago

    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.?

  • patri0t82's avatar
    patri0t82
    Post Patron
    8 years ago

    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!