topic Re: Need a DAX for getting count with filter on 2 columns with OR condition on these 2 columns in DAX Commands and Tips

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

SivaMikkilineni — Wed, 08 Feb 2023 08:16:37 GMT

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.

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

tamerj1 — Wed, 08 Feb 2023 08:18:14 GMT

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

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

SivaMikkilineni — Wed, 08 Feb 2023 08:19:19 GMT

Hi tamerj1
ProductCode, C_Alert, R_Alert are column names

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

FreemanZ — Wed, 08 Feb 2023 08:24:30 GMT

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

)

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

tamerj1 — Wed, 08 Feb 2023 08:24:43 GMT

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

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

SivaMikkilineni — Wed, 08 Feb 2023 09:10:01 GMT

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

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

SivaMikkilineni — Wed, 08 Feb 2023 09:35:04 GMT

FreemanZ This worked, Thanks a lot