dax removefilter not reconize in excel

[nicolast29]

Hi

I created a dashboard in Excel with dax on my computer, it works well

There is some pivot, and i have a measure like this one:

mesure 1:=var nbmois =5
var CAN1p = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2];REMOVEFILTERS(Exercices[Exercices]);Exercices[Exercices]="N-1 Pr")

var CAN1 = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2];REMOVEFILTERS(Exercices[Exercices]);Exercices[Exercices]="N-1")

return
SWITCH (
    TRUE;
    min(Exercices[Exercices] ) = "N"; [Switch SIG Balance 2] / ( [VENTES DE MARCHANDISES + PRODUCTION 2] );
    min(Exercices[Exercices] ) = "N-1"; [Switch SIG Balance 2] / ( [VENTES DE MARCHANDISES + PRODUCTION 2] );
    min(Exercices[Exercices] ) = "Variation"; [Switch SIG Balance 2] /(CAN1*5/12)

As you see i use REMOVEFILTERS

I try to use this dashboard on a another computer, and REMOVEFILTERS isnt' reconize ....
fist time i see that

I try to remove and reinstall Office, same way

If someone have a idea

Thanks

Nicolas

[bhanu_gautam · Accepted solution]

@nicolast29 , Remove filter was introduced after 2016 version so, you can check version and if there is still issue you can use ALL instead of remove filter

mesure 1:=var nbmois =5
var CAN1p = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2], ALL(Exercices[Exercices]), Exercices[Exercices]="N-1 Pr")

var CAN1 = CALCULATE([VENTES DE MARCHANDISES + PRODUCTION 2], ALL(Exercices[Exercices]), Exercices[Exercices]="N-1")

return
SWITCH (
TRUE,
min(Exercices[Exercices]) = "N", [Switch SIG Balance 2] / ([VENTES DE MARCHANDISES + PRODUCTION 2]),
min(Exercices[Exercices]) = "N-1", [Switch SIG Balance 2] / ([VENTES DE MARCHANDISES + PRODUCTION 2]),
min(Exercices[Exercices]) = "Variation", [Switch SIG Balance 2] / (CAN1 * 5 / 12)
)

[nicolast29]

Thanks a lot

Have a nice day