excel-2010powerpivotdaxmeasures

Power Pivot Sum across factTables

I'm having trouble creating a sum across multiple factTables in Power Pivot for Excel 2010.

Here's a simplified layout.

They are all related via dimCalendar. Network A and B have multiple products that are unique to each network.

Each network has a measure to sum its revenue, for example: Network A - Revenue:=SUM([Revenue])

I have created a Pivot Table that has columns for each network's revenue and rows for the date. How can I add a column to the Pivot Table that calculates total revenue across all ad networks per day?

Solution

  • Gee, I must have had a brain cramp yesterday! Here's my solution:

    Total Revenue:=Calculate([Network A - Revenue] + [Network B - Revenue] + [Network C - Revenue])