Forum Discussion

Lionel's avatar
Lionel
New Member
9 years ago
Solved

Count in DAX

 

I have similar table and i have used excel Count formula to calculate column Total. I  wanted to know what is the DAX formula to be used to get similar result in Power BI. 

Thanks

Lionel

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Lionel

    You can create a calculated column.

    Total = IF(ISBLANK(Table1[NCR1]),0,1)+IF(ISBLANK(Table1[NCR2]),0,1)+IF(ISBLANK(Table1[NCR3]),0,1)+IF(ISBLANK(Table1[NCR4]),0,1)+IF(ISBLANK(Table1[NCR5]),0,1)

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    Lionel

    You can create a calculated column.

    Total = IF(ISBLANK(Table1[NCR1]),0,1)+IF(ISBLANK(Table1[NCR2]),0,1)+IF(ISBLANK(Table1[NCR3]),0,1)+IF(ISBLANK(Table1[NCR4]),0,1)+IF(ISBLANK(Table1[NCR5]),0,1)