Forum Discussion
unais
3 years agoHelper V
Subtract Values from Filtered two measure value
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 ...
amitchandak
3 years agoSuper User
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")