Forum Discussion
Caculate simple formula using filter getting wrong
Hi Guys,
I'm new on PowerBI and I'm testing a formula that the result is getting wrong. The result is getting another filter that I didn't applied on the formula...
As we can see on day 01 is getting 130, but the right result is 129 as we can see below, the formula is getting another "tipo" on the column and sum in the result:
Powerbi shoud apply the sum when the column tipo is "Backlog"
Anyone know why this is happing?
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/
7 Replies
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
Hi xexeu
Try this:
Unflow = CALCULATE ( SUM ( '001_03_tblHistorica'[QTD] ), FILTER ( '001_03_tblHistorica', '001_03_tblHistorica'[Tipo] = "Backlog" ) )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/
