topic Count in DAX in Developer

Count in DAX

Lionel — Wed, 18 Jan 2017 08:02:14 GMT

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

Re: Count in DAX

Eric_Zhang — Thu, 19 Jan 2017 07:37:31 GMT

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