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/
xexeu Can you share a screenshot of your data model relationships view please?
Also, have you renamed the fields in the visual? Your visual is showing 'Inflow' but I don't see that in your DAX formula.
Hi AllisonKennedy,
I have only one table, because I'm testing:
The field Inflow is a new column with that formula above.
Thanks for the help
You'll have much more success and flexibility if you get the Power BI star schema, but for now, start by doing Inflow as a new MEASURE not column and see if that helps.
Resource for star schema when you're ready: https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_92.html