Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.