Cumulative Sales

[APini]

I want to write a measure which filters the data by multiple columns.

I want a cumulative total for a product over the course of twelve weeks and then I want to have a measure which shows the performance of an individual sales person to match against the performance of the whole team.

Week Number	Product	Value	Sales Person
1	Apples	£                       10	Annie
1	Apples	£                       10	Jon
1	Apples	£                       10	Tom
1	Apples	£                       10	Jon
1	Apples	£                       10	Annie
1	Apples	£                       10	Jon
1	Apples	£                       10	Dave
1	Apples	£                       10	Tom
1	Apples	£                       10	Jon
1	Apples	£                       10	Annie
2	Apples	£                       10	Dave
2	Apples	£                       10	Annie
2	Apples	£                       10	Tom

I use the following dax formula to get the cumulative total

= CALCULATE(SUM('table'[value]) , FILTER(ALL('table'),table[week number]<=MAX('table'[week number]), VALUE('table'[Product]))

what do I need to add to just get the cumulative sales for Dave?

[vitinho · Accepted solution]

Hi,

Did you try?
= CALCULATE(SUM('table'[value]) ,
                       FILTER(ALL('table'),
                                  AND(table[week number]<=MAX('table'[week number]),
                                          table[Sales Person] = "Dave"),
                       VALUE('table'[Product]))

[APini]

That's great thanks it's worked.