Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
2 years ago
Solved

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

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