Cannot Sum a conditional column in visual

[MichaelRensing]

I am working with some Excel Data, and am creating a new column in the Querry Editor with the following condition:

Basically creating a column for the Area if there is a value in Net pEUI.  This works, and I get a column that has values.  The problem is that this column will not SUM in the Visuals.  Below is a screenshot of the same visual, one using the conditional column (GSF pEUI), the other using the source value column (Total Area):

I am at a loss for why this isn't working.  Any help you can provide is appreciated.

[MichaelRensing]

Thank you. It is indeed SUMing properly.  I was basing my conditional column off the wrong information

[amitchandak · Accepted solution]

@MichaelRensing , if the values are null for Net PEUI, then there will no values. So that many values will reduce from the sum

Seem like working fine

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.