Subtract Values from Filtered two measure value

[unais]

Team,

Refer to the below table need to calculate the value of the total Movement out = Delivery - Return using measure by item

We need to create a chart based on TOP delivered product 

created Two measure  

Delivery QTY by Movment = CALCULATE(SUM(MSEGSUMMARY[QTY]),FILTER(MSEGSUMMARY,MSEGSUMMARY[MOVEMNT]="Delivery"))

Retun  QTY by Movement = CALCULATE(SUM(MSEGSUMMARY[QTY]),FILTER(MSEGSUMMARY,MSEGSUMMARY[MOVEMNT]="Retun"))

Delivery QTY: difference of both measure values coming to Zero Please advise

Material	Date	Movement	QTY
A	01.01.2021	Delivery	5
A	02.01.2021	Delivery	6
B	01.01.2021	Delivery	6
A	03.01.2021	Return	2

[unais]

team,

any one to support

[unais]

team , any support

[unais]

hi @amitchandak  Delivery QTY by Movement - Retun QTY by Movement becoming zero always..

[amitchandak]

@unais , Because Movement is used in visuals.

OR Try like

Delivery QTY by Movment = CALCULATE(SUM(MSEGSUMMARY[QTY]),MSEGSUMMARY[MOVEMNT]="Delivery")

Retun QTY by Movement = CALCULATE(SUM(MSEGSUMMARY[QTY]),MSEGSUMMARY[MOVEMNT]="Retun")