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

[watje255_ju]

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

[tamerj1 · Accepted solution]

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

[watje255_ju]

Thanks!!