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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Wichi
Regular Visitor

Dynamic subtraction for a measure with multiple filters

Hi all & Happy weekend 

 

I am looking for the correct way in DAX to have a measure written, which substracts the displayed values based on multiple filters. I posted the picture below and essentially I can have various filters (e.g. material, date, bucket, country,..) which are influencing the displayed value of my measure.

Now I would like to create a measure which substracts the displayed values in the buckets. 

For Example; Salesweek 202328, MSU Germany, I would like to know the result of  substracting Bucket "1" - Bucket "2"; in numbers 

151,858,04 - 208,192,09

 

 

dynamic difference.PNG

 

Many Thanks!

2 REPLIES 2
Wichi
Regular Visitor

Hi ! 

 

I do understand the point around the sample data, yet currently it is not possible for me to provide a sample dataset at this point. I was thinking to get a more generic idea on how to approach this (e.g. with summarize?)

 

So I put the tables below, does that help ?

 

Ingoing position

BPCL5MSUDescBucketComponentLevel1Sum of ComponentForecastSalesWeek
Germany1Promo151.858202328
Germany1Promo159.275202329
Germany1Promo250.468202330
Germany1Promo307.138202331
Germany1Promo242.284202332
Germany2Promo208.192202328
Germany2Promo122.548202329
Germany2Promo175.637202330
Germany2Promo279.969202331
Germany2Promo214.924202332

 

The desired outcome as below as addition 

 

BPCL5MSUDescBucketComponentLevel1Sum of ComponentForecastSalesWeek
Germany1Promo151.858202328
Germany1Promo159.275202329
Germany1Promo250.468202330
Germany1Promo307.138202331
Germany1Promo242.284202332
Germany2Promo208.192202328
Germany2Promo122.548202329
Germany2Promo175.637202330
Germany2Promo279.969202331
Germany2Promo214.924202332
GermanyDiff 1-2Promo-56.334202328
GermanyDiff 1-2Promo36.727202329
GermanyDiff 1-2Promo74.831202330
GermanyDiff 1-2Promo27.169202331
GermanyDiff 1-2Promo27.360202332
Ritaf1983
Super User
Super User

Hi @Wichi 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.