Need a DAX for getting count with filter on 2 columns with OR condition on these 2 columns

[SivaMikkilineni]

Hi, I have a table as below

ProductCode	C_Alert	R_Alert
101	1	0
102	7	0
103	0	0
104	0	5
105	0	0
106	0	8
107	3	0
108	0	0

I need the count of ProductCode with below 2 condition 
- C_Alert >0 OR R_Alert>0
- C_Alert=0 AND R_Alert=0

So, the result I am expecting is Count as 5 with OR condition and Count as 3 with AND condition.

Can someone please help with a proper DAX for my requirement. I have tried to get the count by unable to use OR/AND conditions.  

[FreemanZ]

hi  @SivaMikkilineni

something like:

count  =

COUNTROWS(

    FILTER(

        TableName,

        OR(

            TableName[C_Alert]>0 || TableName[R_Alert]>0,

            TableName[C_Alert]=0 && TableName[R_Alert]=0

        )

    )

)

[SivaMikkilineni]

@FreemanZ This worked, Thanks a lot

[tamerj1]

Hi @SivaMikkilineni 
Are [C_Alert] and [R_Alert] measures or columns?

[SivaMikkilineni]

Hi @tamerj1 
ProductCode, C_Alert, R_Alert are column names

[tamerj1]

@SivaMikkilineni 
Assuming ProductCode is a primary key in the table you can use

=
COUNTROWS ( FILTER ( 'Table', 'Table'[C_Alert] > 0 || 'Table'[R_Alert] > 0 ) )

=
COUNTROWS ( FILTER ( 'Table', 'Table'[C_Alert] = 0 && 'Table'[R_Alert] = 0 ) )

Please let me know if otherwize

[SivaMikkilineni]

Hi @tamerj1 
Thanks for the reply, but can I get the result within a single DAX ?
Result should give me the ProductCount according to OR/AND condition