Power BI - SUM calculation with N/A or NA records

[PBI_V2]

Hello All,

We have value column in the source which contains values for multiple attributes as values as "NA" meaning not applicable.

Below is the sample report:

We need to create a measure which will show the summation of values in such a way that 

1) If we calculate region wise then SUM all values & show the summation

2) If we calculate Year wise then SUM all values & show the summation

3) if we calculate Region & year wise and there is no NA then show summation

4) if we calculate Region & year wise and there is all NA values then show NA

Kindly suggest how to create such measure.

Thanks,

PBI V2

[ray_aramburo · Accepted solution]

You will not be able to SUM values with an explicit NA value since you can't combine numeric and text data. You need to replace NA with 0 or some default value you define. Then the measure is as easy as SUM(Table[ColumnName]).