Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
PBI_V2
Helper IV
Helper IV

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

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:

PBI_V2_1-1701787905242.png

 

 

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

1 ACCEPTED SOLUTION
ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
ray_aramburo
Super User
Super User

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





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.