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,

     

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,