Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.