ignore active slicer

[MagikJukas]

Hello,

I have a table with Qty, materials, several material classifications and date.

In my report I have a date slicer. I wish to create a measure that ignore the slicer.

I do no want a solution involving the "Edit interactions"!

I need a measure that ignores the date selected in the slicer, since I will apply some extra conditions later on.

I tried to use the following formula: Calculate(SUM(Qty),removefilters(date))

it keeps on showing the value filtered.

any idea?

thanks

[DimaMD]

Hi @MagikJukas we are from Ukraine.
Have you tried the "ALL" function?
Calculate(SUM(Qty),ALL(date))

Give an example of the data for a more accurate understanding

[MagikJukas · Accepted solution]

I figured it out.

my slicer is showing the date in months. 

Calculate(SUM(Qty),removefilters(date.[Month])).

now it works