topic Re: how to do count if(s) in DAX Commands and Tips

how to do count if(s)

Maz_0102 — Wed, 13 Apr 2022 10:05:20 GMT

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 — Wed, 13 Apr 2022 11:04:19 GMT

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

Maz_0102 — Wed, 13 Apr 2022 11:07:14 GMT

tamerj1 thank you so much!