A sum of a column with numbers and blank values with a blank result

Anonymous — Thu, 06 Apr 2023 07:09:45 GMT

So the point is that whenever you add numbers together and there is a blank value, the result must always be blank. If the blank value does not appear in the sum of the column, then it is a number value.

How can you manipulate this outcome?

Table

Category	value
a	1
b
c	3

The sum(table[value])
total = BLANK

Re: A sum of a column with numbers and blank values with a blank result

OwenAuger — Thu, 06 Apr 2023 12:01:17 GMT

Hi Anonymous

Interesting and unusual requirement 🙂

You could use COUNTBLANK to determine if at least one BLANK value is present, and if so return BLANK, otherwise return the sum.

A concise way of putting it could be:

SUM modified = IF ( NOT COUNTBLANK ( 'table'[value] ), SUM ( 'table'[value] ) )

If the value returned by COUNTBLANK(...) is nonzero, it will be cast to the value TRUE, and then NOT COUNTBLANK(...) will be FALSE.

Does this work for you?

topic Re: A sum of a column with numbers and blank values with a blank result in DAX Commands and Tips

A sum of a column with numbers and blank values with a blank result

Re: A sum of a column with numbers and blank values with a blank result