Forum Discussion
Caculate simple formula using filter getting wrong
Do you want a measure or a new column? the previous post I shared is good if you want to create a measure, if you want a new column use this:
Unflow = CALCULATE ( SUM ( '001_03_tblHistorica'[QTD] ), FILTER ( '001_03_tblHistorica', '001_03_tblHistorica'[Tipo] = "Backlog" && '001_03_tblHistorica'[Visao] = EARLIER ( '001_03_tblHistorica'[Visao] ) ) )or just use the below one to show the value if the TIPO=Backlog:
New Column = IF(Tipo] = "Backlog",[QTD],blank())If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Do you want a measure or a new column? the previous post I shared is good if you want to create a measure, if you want a new column use this:
Unflow =
CALCULATE (
SUM ( '001_03_tblHistorica'[QTD] ),
FILTER (
'001_03_tblHistorica',
'001_03_tblHistorica'[Tipo] = "Backlog"
&& '001_03_tblHistorica'[Visao] = EARLIER ( '001_03_tblHistorica'[Visao] )
)
)
or just use the below one to show the value if the TIPO=Backlog:
New Column =
IF(Tipo] = "Backlog",[QTD],blank())
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/