DAX CALCULATE ALL SALES except year filter

[pedroccamaraDBI]

Hello all. I hope everyone's ok
I don't know how to do this measure above, probably because i don't understand yet the concept or the rules.
I need to calculate [Net Sales] in this report but ignoring all filters except the year filter.
I've tried something like this but it's not working

All Sales = CALCULATE( [Net Sales], [Year Selected] = 'Tab Dates'[Year])
Can somebody help me? And it would be awesome with an explanation
Thanks a lot
Stay safe and healthy
Pedro

[bcdobbs · Accepted solution]

Not 100% sure on your data model/tables etc but generally you want to do something like this:

All Sales = 
	CALCULATE( 
		[Net Sales],
		REMOVEFILTERS (),
		VALUES('Tab Dates'[Year])
	)

Removefilters without any parameters takes away all filters.

The values line then adds back in any existing filter on the year.

Have a read of this for more detail: Using ALLEXCEPT versus ALL and VALUES - SQLBI

(Note REMOVEFILTERS is the same as ALL it just makes the code easier to understand!)

[pedroccamaraDBI]

Hello @bcdobbs 
It worked perfectly. And thanks a lot for the explanation. Awesome!!!
Stay safe my pbi friend😁