Help with a measure (CALCULATE)

[luizahenriques]

Hello!

I have the follow measure:

Nota Anterior excluindo requisitos excluídos =

var statu = Medidas[StatusRequisito]

return CALCULATE([Nota Final Ciclo Anterior],filter(d_Requisito,statu<>"Excluído")).

 

I want to calculate the measure [Nota Final Ciclo Anterior] desregarding the status "Excluído".

This measure resulted in this table:

But the total value was the same than the measure without the filter. Why? The measure works very well line to line but when it calculate the total, the filter don't work.

Thank you so much!

[amitchandak]

@luizahenriques , Make sure this is a measure, not a column

Nota Anterior excluindo requisitos excluídos =
var statu =
return CALCULATE(Sum(Medidas[Nota Final Ciclo Anterior]) ,filter(Medidas, Medidas[StatusRequisito],statu<>"Excluído"))

Sum if [Nota Final Ciclo Anterior] is column, else use [Nota Final Ciclo Anterior]

[luizahenriques]

This "[Nota Final Ciclo Anterior]" is a measure. But if I use CALCULATE([Nota Final Ciclo Anterior],filter(d_Requisito,statu<>"Excluído")). happens this problem with the total line. The total line calculation doesn't filter the statu <> "Excluído".