how to do count if(s)

[Maz_0102]

Hi guys

i want to do count if on the amount of values i have in a table using a condition on a status column 

i want to exclude declined only counting approced and submitted

please can you advise

in excel it would be a normal countifs =COUNTIFS(status column, "<>declined")

[tamerj1 · Accepted solution]

Hi @Maz_0102 
Using a measure In DAX we write
CALCULATE ( COUNTROWS ( Table ), Table[status column] <> "declined" )

[Maz_0102]

@tamerj1 thank you so much!