Trouble with Calculate and Measures

[JonCastilho]

I've this measure:

 - Mês Atual = MAX('BD Custos Serv'[Mes])

which I use to get the most recent month, giving all the data I'm currently working with. 

This next measure:

 - Custo Mês Atual = CALCULATE(SUM('BD Custos Serv'[Custo])

                                 ,FILTER('BD Custos Serv', 'BD Custos Serv'[Mes]='BD Custos Serv'[Mês Atual]))

should give me the summed up cost for that current month, but it gives me the total cost as it had been calculated with no filter at all.

Any help is appreciated! Thanks in advance!

[Greg_Deckler · Accepted solution]

@JonCastilho - Try this:

Custo Mês Atual = 
  VAR __MesAtual = [Mes Atual]
RETURN
  CALCULATE(SUM('BD Custos Serv'[Custo]),FILTER('BD Custos Serv', 'BD Custos Serv'[Mes]=__MesAtual))

[JonCastilho]

Worked like a charm! Thanks a lot!