Need to calculate the this measure

[arif_sqit]

Hi Experts,

I am calculating this measure where I have one movement material table and order date both have dates column which is directly connected to calendar table, Now I have made one virtual physical table.

I need to force the measure in the right table to follow filtering based on @grdate column of the virtual table in measure. Means to say if i slice the date filter above i need the measure to summarize the values based on @grdate column and not on Document date column. so basically I need to calcualte this measure without virtual table

please find this Pbix file.

[Anonymous]

Hi @arif_sqit ,

Can you show more details? I can neither see the formula nor reach the Pbix file.

Best Regards,

Jay

[mattww]

Hi @arif_sqit 

Your query is quite hard to follow, I think it might benefit from a screenshot of your model and any existing measures you have in place

Matt