Filtering Measure using a Slicer

[bboschert]

Good Morning!

I'm looking to see if theres a way that I can filter a measure using a slicer so that the measure only takes into account what is actually visible on the screen instead of just looking at all the background data. Heres my example:

Here I have a status report with 2 date filters and some measures in the table. The first measure is TotalCurrentQty = CALCULATE(SUMX(currentQty,currentQty[ReelQty]),USERELATIONSHIP(BalanceQuery[Owner],currentQty[cqOwner]))

Which all it does is sum up a quantity where the Owners of the 2 queries are the same. The next is 

TotalPurchaseQty = CALCULATE(SUMX(purchasedQty, (purchasedQty[QtyOrdered] - purchasedQty[QtyReceived])), USERELATIONSHIP(BalanceQuery[Owner],purchasedQty[pqOwner])) Which does the same calculation but for the total purchased quantity instead of the current quantity. Lastly I have a balance measure 

Balance = CALCULATE([TotalCurrentQty] + [TotalPurchaseQty] - SUMX(allocatedQty, allocatedQty[Allocated]), USERELATIONSHIP(allocatedQty[aqOwner],BalanceQuery[Owner])) Which combines both measures and the subtracts it from the total allocated quantity based on the parameters given. The 3 filters at the top are just a text filter for the stock code, the earliest print date (date for that comes out of the allocated table on the bottom right), and the delivery date (which is the date from the top right table coming out of the purchased quantity table.) The issue I have is I have the delivery date filter set to not filter the left hand table or the bottom right table because if it doesn't see a stock code in the table it would act as if they are all blank which is not necessarily the case. However when I filter the delivery date to look for deliveries in the next week the balance measure is not affected like so:

What I am trying to accomplish is to get the balance here to reflect on the data that is currently showing. Since there is no delivering quantity then we should just be taking the current quantity from the left table and subtracting it from the sum of the allocated quantity from the bottom right table. 

Is this even a possibility? I've tried ISSELECTED and still didn't get accurate results. Thanks in advance!

[v-piga-msft · Accepted solution]

Hi @bboschert ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @bboschert ,

To understand your scenario, you'd better share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best  Regards,

Cherry