Forum Discussion

Wattar's avatar
Wattar
Helper I
6 years ago

Help with calculate

Hello,

 

I am trying to calculte a measure using this formula:

Cible N+1 =
VAR ANNEE_N1 = MIN(Effectif0[Année])+1
RETURN
CALCULATE(SUM(SC[Effectif Cible]);'Dim_Années'[Année]== ANNEE_N1)
where ANNEE_N1 = 2021, the calcuation is correct, but the result appears only in front of the year 2020, any ideas why? 
 
 

Thank you for help.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Wattar , try like

    Cible N+1 =
    VAR ANNEE_N1 = MINX(Effectif0,Effectif0[Année])+1
    RETURN
    CALCULATE(SUM(SC[Effectif Cible]);'Dim_Années'[Année]== ANNEE_N1)

    • Wattar's avatar
      Wattar
      Helper I
      6 years ago

      Thanks for you reply, but I get the same result

      • Wattar's avatar
        Wattar
        Helper I
        6 years ago

        When I use 2020 instead of the variable it works juts fine