Forum Discussion
Is Row wise COUNTIF possible in powerBI?
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.
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,
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
)