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
1 ACCEPTED SOLUTION
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)
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)
Helpful resources
Fabric Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
