using the function all in a filtered table

[arturo971]

Hello,

i have a question using the function all but with a filtered tableto create a measure, my data look like this:

i would like to create a measure that give me the grand total for all the skus but only for the year 2015=50, i am currently stuck with this formula:

 CALCULATE(SUM(data[sales]),ALL(data[sku]),data[year]=2015)

But as you can imagine it doesnt work.

Thank for your help.

[MattAllington · Accepted solution]

Edit. Use all(data) instead of all(data[sku])