Forum Discussion

dd88's avatar
dd88
Icon for Post Patron rankPost Patron
3 years ago

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 T...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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

dd88's avatar
dd88
Icon for Post Patron rankPost Patron
3 years ago

Many thanks amitchandak  

I used your suggestion Option 1

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

 

And it worked! Many thanks again ..