Forum Discussion

benz-fsproduce's avatar
benz-fsproduce
Frequent Visitor
4 years ago
Solved

Countif

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!

 

Need Help
  • ChristianDGreat's avatar
    ChristianDGreat
    4 years ago

    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
     

1 Reply

  • ChristianDGreat's avatar
    ChristianDGreat
    Resolver I
    4 years ago

    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