Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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.

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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
)
  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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,