Forum Discussion

luizahenriques's avatar
luizahenriques
Frequent Visitor
4 years ago

Help with a measure (CALCULATE)

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!

 

 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      luizahenriques
      Frequent Visitor
      4 years ago

      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".