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
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 |
team,
any one to support
team , any support
hi @amitchandak Delivery QTY by Movement - Retun QTY by Movement becoming zero always..
@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")
User | Count |
---|---|
139 | |
84 | |
62 | |
60 | |
57 |
User | Count |
---|---|
211 | |
108 | |
89 | |
76 | |
72 |