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!