Remove Date Filter Context within Measure , and lookup value from measure result?

watje255_ju — Sat, 18 Feb 2023 09:34:56 GMT

Hello,

For each batch / test (from Test_Attributes Fact Table) I would like to also show the cost /kg ( from Procurement table). The batch numbers between the two tables are the same.

However, the latest test results are sometimes months after the product was purchased, therefore as the date relationships are based on the quite recent test date ( Test Attributes Fact Table) and the historic procurement (Procurement table) the slicer filters out the cost.

For example, the cost/kg shows up for batch 769-744-21 with no slicer, but disappers when changing the slicer after the procurement date, but includes the last test day.

I tried to use ALL to take the filter context off the date, but its still not returning a cost, any reason why/how to pull the cost through regardless of the date slicer?

Also, is it possible to pull through cost/kg based off the voucher number? Some batches have the same voucher number, but no cost associated with the batch, I would like to pull through the cost/kg for that voucher and apply it against all batches with the same voucher number, is this possible? E.g in this example, all batches have voucher number PIV001, so I want to pull through the same cost for these guys, not just the two batches?

Thanks for any help with A or B! PBIX file link Results_Test.pbix

Re: Remove Date Filter Context within Measure , and lookup value from measure result?

tamerj1 — Sat, 18 Feb 2023 09:55:01 GMT

Hi watje255_ju

Placing a variable inside CALCULATE won't work as variables are calculated only once. Just wrap the inner CALCULATE with the outer CALCULATE without using the variable COST

Re: Remove Date Filter Context within Measure , and lookup value from measure result?

watje255_ju — Sat, 18 Feb 2023 10:11:23 GMT

Thanks!!

topic Re: Remove Date Filter Context within Measure , and lookup value from measure result? in DAX Commands and Tips

Remove Date Filter Context within Measure , and lookup value from measure result?

Re: Remove Date Filter Context within Measure , and lookup value from measure result?

Re: Remove Date Filter Context within Measure , and lookup value from measure result?