Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

DATE FILTER

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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]))