cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
unais
Helper V
Helper V

Subtract Values from Filtered two measure value

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  

Delivery QTY by Movment = CALCULATE(SUM(MSEGSUMMARY[QTY]),FILTER(MSEGSUMMARY,MSEGSUMMARY[MOVEMNT]="Delivery"))

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

MaterialDateMovementQTY
A01.01.2021Delivery5
A02.01.2021Delivery6
B01.01.2021Delivery6
A03.01.2021Return2

 

 

4 REPLIES 4
unais
Helper V
Helper V

team,

any one to support

unais
Helper V
Helper V

team , any support

unais
Helper V
Helper V

hi @amitchandak  Delivery QTY by Movement - Retun QTY by Movement becoming zero always..

amitchandak
Super User
Super User

@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")

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors