Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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")
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
103 | |
103 | |
87 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |