DATE FILTER

[Syndicate_Admin]

Good afternoon!

I'm having trouble getting a DAX measure that allows me to do the following:

I would like to have a measure that added the sales of 3 different years and I could keep it in a column of my matrix without the YEARS filter changing the values.

However, I would like the MES filter to affect the measure.

Can you think of any way?

Thanks in advance,

Victor

[pranit828]

Hi @Syndicate_Admin 

Please always provide more context with peoblem examples and expected output with screenshots. 

From what I understand. You need to use the below.

Calc = CALCULATE(SUM(table[sales]), ALLEXCEPT(Table,Table[Years]))