SUM of PREVIOUS YEAR ignore filter/slicer selection
I read a few similar threads but couldn't find one that would work with my measure. My measure DEVIS_N-1 which calculate sum of number of futures contract in the previous year doesn't react to the slicer "Etat de devis" like the mesure DEVIS_N (which calculate sum of number of futures contract in the year selected).
Below is my DAX formule for DEVIS_N and DEVIS_N-1:
I have try to use this mesure below but it doesn't work :
Devis N-1 Test = VAR Selected_etat_devis = SELECTEDVALUE(Polices_devis[Etat du devis])
CALCULATE('Mesure DEVIS'[DEVIS_N-1], FILTER(Polices_devis, Polices_devis[Etat du devis] = Selected_etat_devis))
I need to use allexcept, if not the function doesn't work like the way you suggested. In addition, my date table is table "Periode", because I need to calculate the total by month so I coundn't use or create the date table like you suggested because it has no meaning in my case.