Count in DAX

[Lionel]

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

[Eric_Zhang · Accepted solution]

@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)