Help with calculate

[Wattar]

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.

[amitchandak]

@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]

Thanks for you reply, but I get the same result

[Wattar]

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

[v-easonf-msft]

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