Calculate the week-to-week evolution

[yamina]

Hello 

I want to calculate the week to week evolution

evol semaine =

VAR _CurrentWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO]= [Max de semaine S])

VAR _PreviousWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO]= [Max de S-1])

RETURN

    _CurrentWeekCases - _PreviousWeekCases

I don't understand the error message box

Can you help me to solve this issue please ? 

[bhanu_gautam · Accepted solution]

@yamina , Try below mentioned measure

DAX
evol semaine =
VAR _CurrentWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]))
VAR _PreviousWeekCases = CALCULATE(COUNT('Fichiers Sources'[num_dossier]), 'Calendrier'[Semaine ISO] = MAX('Calendrier'[Semaine ISO]) - 1)
RETURN
_CurrentWeekCases - _PreviousWeekCases

[yamina]

@bhanu_gautam  thank you very much.