Is Row wise COUNTIF possible in powerBI?

[Anonymous]

Hey everyone,

I need a power BI equivalent of excel COUNTIF function, like in the image attached below DAX should be row wise.

Any ideas?

Many thanks.

[v-sihou-msft · Accepted solution]

@Anonymous

In your scenario, you need to check columns from Sales to Profit. There's no ":" to select multiple columns in DAX, you have to apply condition on all columns in your calculated column like below:

Column=
IF (
    Table[Sales] = 0
        || Table[Quantity] = 0
        || Table[Discount] = 0
        || Table[Profit] = 0,
    1,
    0
)

Regards,

[Anonymous]

Yes, just you do it differently.  You would count each column separately.  Here is an example for you:

CountIFLike = CALCULATE(
	countrows('MyTable'),
	not 'Mytable'[MyField] = 0
)