Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I have the follow measure:
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!
@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]
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".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |