Forum Discussion

Wattar's avatar
Wattar
Icon for Helper I rankHelper 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) whe...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    6 years ago

    Thanks for you reply, but I get the same result

    • Wattar's avatar
      Wattar
      Icon for Helper I rankHelper I
      6 years ago

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

      • v-easonf-msft's avatar
        v-easonf-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi , Wattar 

        The year field in your measure involves multiple tables.Is the "year" field in the matrix visualization a year in the date hierarchy, or is it a field containing only the year?

         

        I'm not sure what effect you want to achieve with your measure.

        Could you please share your sample data and desired output screenshots for further analysis?

         

        Best Regards,
        Community Support Team _ Eason