Roll-up calculations that use SELECTEDVALUE

[djbuncle]

Hi. I have a situation where I can't aggregate/rollup a calculation as the values I'm calculating require the context of a campaign at the more granular level.

E.g. The top pivot shows the [Deposit Value 3d] calculation working using the [Campaign Date] to then sum the deposits over a 3 day range thereafter.

However in the 2nd pivot where the [Campaign Id] and [Campaign Date] attributes are removed, the [Deposit Value 3d] value returns blank as I suspect it doesn't understand the context of the date range it needs to calculate the deposits over. Obviously I would like this to be the sum of all the campaigns. Below is the calculation I currently use.

Deposit Value 3d:=

  VAR StartDate = SELECTEDVALUE('Campaign'[Campaign Date])

  VAR EndDate = SELECTEDVALUE('Campaign'[Post Campaign Marker End])

  RETURN CALCULATE([Deposit Value], FILTER('Activity Date', 'Activity Date'[Activity Date] >= StartDate && 'Activity Date'[Activity Date] <= EndDate))

Is there a way I can achieve this?

Thanks.