Calculate is giving me different result

[Anonymous]

Hello,

I am calculating a normal sum function with a filter but for some reason the sum is giving me wrong results

My formula:

CT2 = Calculation (Sales CY,FacCustomerSales{Item Group ID}="Add.charge")
I am not sure why the total is adding those 2 lines in yellow = 41 226 + 31 712 = 72 937

However the SUM should be 0$

[AlexisOlson · Accepted solution]

When you write FacCustomerSales[Item Group ID] = "Add.charge" as a filter argument, the "Add.Charge" bit replaces the current filter context for [Item Group ID] rather than adding that as an additional filter.

If you want to keep that filter context then use KEEPFILTERS ( FacCustomerSales[Item Group ID] = "Add.charge" ).

[Anonymous]

Thank you Alexis, I figure out the problem, I had the filter to the wrong table