Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Resolver I
Resolver I

Sum multiple columns values, how to?

I would like to ..


Obtain the total count of blank values in Column A

These are true blank values.


Obtain the total count of blank values in Column B


Then add the values. and store the Total in a new field.



So far I have done the following, however not sure if this is best practice.


CountBlankSystem1EmployeeID = COUNTBLANK('Table'[System 1 Employee ID])

Column Formatted as Whole Number

Returns the number 39


CountBlankSystem2EmployeeID = COUNTBLANK('Table'[System 2 Employee ID])

Column Formatted as Whole Number

Returns the number 17


Now I need to work out how to add the values of 39+17 = 56

Note these totals will update with new data uploads from Excel.





Super User
Super User

@dd88 , Create a new measure

[CountBlankSystem1EmployeeID] +[CountBlankSystem2EmployeeID]


or create a measure


countows(filter(Table, isblank('Table'[System 1 Employee ID])) || isblank('Table'[System 2 Employee ID])) ) )

and another question is ..


I currently have the following counts for


Total Mismatches = 4

TotalBlank EmployeeID System 1 = 1

TotalBlank EmployeeID System 2 = 1


The last count to workout is total mistmatches. ie (EmployeeID System 1 is not blank) AND (EmployeeID System 2 is not blank) = 2


How can I achieve this?


Create a new calculated column, new measure?


Eg Total Mismatches – (TotalBlank EmployeeID System 1 - TotalBlank EmployeeID System 2)




Note: ideally there is a unique employeeID that is the key. Unfortunately the data is from active legacy separate systems. I am performing a data clean-up across both systems. To do data migration/ preparation into a new system which will have a unique employeeID.


An example data set is





Many thanks @amitchandak  

I used your suggestion Option 1

Create a new calculated column 
Total = [CountBlankSystem1EmployeeID] +[CountBlankSystem2EmployeeID]


And it worked! Many thanks again ..

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.