# Sum of Measures

• ### Question

• I have 9 measures for one of my PowerPivot tables. Each of these measures calculates the total of the investment a certain company made in one of the 9 advertisement channels. I would also like to have the total investment that company made, so I would need to Sum these measures.

However, simply trying 'Total:= Measure1 + Measure2 + ...' gives me the error: "Semantic Error: The expression refers to multiple columns. Multiple columns can not be converted to a scalar value".

Any ideas?

Monday, June 2, 2014 8:04 AM

• I think that the next step would be to try it on our own. Is there any way that you could share a sample of your data model?

I have no clue of what's going on behind the scenes but, in theory, the

`Total:= [Measure1] + [Measure2] `

should work

Tuesday, June 3, 2014 7:26 AM

### All replies

• Hi ,

I have tried a sample data and this kind of measure is working fine for me. BTW , could you put your formula as

`Total:= [Measure1] + [Measure2] `

Best Regards Sorna

Monday, June 2, 2014 8:39 AM
• Maybe I should've included my measures. Here's one of them, the other are fairly similar, but just contain other row from other tables, while still having the same data type.

`Radio:=CALCULATE(SUM(Radio[RadioInvestment]); ALL(Radio[MDBID]); FILTER(VALUES(Campaigns[MDBID]); COUNTROWS(RelatedTable('Adverteerder-Campagne')) > 0))`

Monday, June 2, 2014 8:48 AM
• it seems like one of your measures is giving you a table instead of giving you just one value (scalar value)

Try this:

1. Add all of the measures to your current pivot table with all the slicers, column & row headers that you may need
2. if one of them breaks the pivot table, you've found the reason why it doesn't work

Hope this helps

Monday, June 2, 2014 9:21 AM
• These are all the measures that I want to Sum, all just giving a value

Monday, June 2, 2014 9:33 AM
• In theory, you shouldn't have any issues, but some measures just don't interact well together in a pivot table. Did you get any errors when you added all of them to a single pivot table?

They might all be giving you numeric values, but - will they blend? *that's the enigma*

Monday, June 2, 2014 10:05 AM
• Nope, adding all of them to a single pivot table will give me the exact same numbers as in the picture above (when no filters are present of course)
Monday, June 2, 2014 10:52 AM
• I think that the next step would be to try it on our own. Is there any way that you could share a sample of your data model?

I have no clue of what's going on behind the scenes but, in theory, the

`Total:= [Measure1] + [Measure2] `

should work

Tuesday, June 3, 2014 7:26 AM