Countif

[benz-fsproduce]

Hi, I am trying to do a "countif" function in Power Bi. I know that the formula does not work in Power Bi like it does in Excel. I created a formula for each column to show when employees were terminated within certain day ranges. If an employee was terminated within a certain range the value shows "1" and false "0". I would like to add a new measure for each of the columns "0-15 terms", "16-30" terms etc. I want the new measure to count all of the values "1". I have added a screen shot of what I am talking about. Thanks!

[ChristianDGreat · Accepted solution]

I dont get how you have your table setup but i hope this works.

Count = 
CALCULATE(
    COUNT('Table'[0-15]),
    'Table'[0-15]=1
)

Just replace the 'Table'[0-15] with your other columns