Basic Calculate Formula not working

[Kfausch]

Hello,

I have 1 table and 2 formulas, all pretty basic stuff I have done dozens of times, but one of my formulas is doing something different and I'm not sure why. I have 1 formula that sums the quantity and another that sums the quantity for a particular entry type. 

QTY = SUM('Value Entries'[Item_Ledger_Entry_Quantity])

Consumption Qty = CALCULATE([QTY], 'Value Entries'[Item_Ledger_Entry_Type] = "Consumption")

Instead of just calculating the sum of the Consumption entries, its duplicating that value to other types like this.

Consumption Qty	Item_Ledger_Entry_Type	QTY
-592003278	Consumption	-592003278.5
-592003278	Output	279198525.1

Typically when added the fields like this it wouldn't show the output line or the Consumption quantity would be 0. The QTY formula is working fine.

Anyone have any idea why it would do this?

Thanks for reading!

[Kfausch · Accepted solution]

I figured it out, it some something I was doing with my page filters.

[amitchandak]

Formula seems fine. Can you share a sample pbix after removing sensitive information