Forum Discussion
dax removefilter not reconize in excel
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
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)
)
2 Replies
- bhanu_gautam
Super User
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
Helper V
Thanks a lot
Have a nice day