Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |