The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |