Forum Discussion

dd88's avatar
dd88
Post 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
Super 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])) ) )