Answered by:
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
Answers

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
 Proposed as answer by Ed Price  MSFTMicrosoft employee Friday, June 27, 2014 11:57 PM
 Marked as answer by Ed Price  MSFTMicrosoft employee Tuesday, July 8, 2014 2:36 AM
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('AdverteerderCampagne')) > 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:
 Add all of the measures to your current pivot table with all the slicers, column & row headers that you may need
 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
 Proposed as answer by Ed Price  MSFTMicrosoft employee Friday, June 27, 2014 11:57 PM
 Marked as answer by Ed Price  MSFTMicrosoft employee Tuesday, July 8, 2014 2:36 AM
Tuesday, June 3, 2014 7:26 AM