Running Total by multiple columns

[Anonymous]

Hey guys,

I'm trying to calculate cumulative values based on multiple filters. I have the following measure in place right now:

Cumulative Conversions = 
CALCULATE( SUM(Conversions[Total Conversions]),
	   FILTER(
		ALL(Conversions),
		Conversions[Date] <= MAX(Conversions[Date])
	   ),values(Conversions[Insertion Order])
)

So this shows the cumulative number of conversions over the course of time when I display this in a line and column chart. They are grouped by 'Insertion Order'. This way, I can select a few Insertion Orders using a slicer to display the respective data.

However, I would also like to be able to filter on 'Conversion Pixel', which is a column in the same dataset, Using this formula it only counts the total number of conversion per insertion order and does not take into account any of the filters I apply.

I've tried to add VALUES(Conversions[Conversion Pixel]) to the formula. Because not every conversion pixel has a value on every date, it won't display the total number of conversions of the conversion pixels selected over the entire lifetime.

Take the example above. From the 10th of June, the 'Info page' pixel does not generate data anymore. I do, however, want to take this data into account while calculating the running total. So basically make sure that the running totals are shown based on the total amount of conversions generated over the lifetime of the Insertion Order.

Can anyone help me with this?

[kdejonge · Accepted solution]

instead of 

ALL(Conversions)

you can do

ALLEXCEPT(Conversions, Conversions[Conversion Pixel])

[Anonymous]

@kdejongeThanks, works like a charm.