Sum measure and column values as a new measure in a table visual

[Anonymous]

I have a table visual that includes a measure ("Adjustment Qty") and a column ("PHYSICALINVENT") from related tables in the data model.  I want to add a 4th column to the visual that sums "Adjustment Qty" and "PHYSICALINVENT" for each row in the visual. 

Is this possible? What measure formula would work?

[Anonymous · Accepted solution]

I created a new measure for SUM(PHYSICALINVENT). That could be summed with the measure "Adjustment Qty" in another measure.

[Anonymous]

@parry2k Here is the expected output:

where 

Adjustment Qty = BOMLine +  ProdLine + TransferOrderReceive

Needed Qty = PHYSICALINVENT + Adjustment Qty

And sample data:

ITEMID	WMSLOCATIONID	PHYSICALINVENT
ACM-PACK	ZTEMP	10050
ACM-PACK	101W	10050
ACM-PACK	BLANK	7105
B/COAST.CAR.CB	BLANK	162
B/FRP42	SCRAP	20
B/FRP42	101W	5000
B/FRP42	BLANK	1293
B/ZFCD02	SCRAP	3800
B/ZFCD02	BLANK	3331
B/ZFCD51	SCRAP	1200
B/ZFCD51	BLANK	2709

ITEMID	REFTYPE	QTY
ACM-PACK	BOMLine	-552
ACM-PACK	ProdLine	-1472
ACM-PACK	TransferOrderReceive	10050
B/COAST.CAR.CB	ProdLine	-17
B/FRP42	ProdLine	-1287
B/FRP42	TransferOrderReceive	5000
B/ZFCD02	BOMLine	-544
B/ZFCD02	ProdLine	-2907
B/ZFCD51	BOMLine	-142
B/ZFCD51	ProdLine	-575

[parry2k]

@Anonymous can you share sample data and the expected output?