Do the further calculation of measure, using column data

[naoyixue1]

Hey there,

I now have the measure to calculate the weekly forecast in bottle in SKU level. But I try to furhter calculate that measure based on the relationship between bottle and case in SKU level, coverting the measure from bottle to cases....

Right now, i have the SKU lookup table ,which indicates the relationshio between bottle and cases for each SKU. But it seems I really cannot link that relationship in the table to do the further calculation of my measure. Given that, I applied the ADDCOLUMN DAX to try to add the SKU level forecast in my SKU lookup table, but failed.

DO you guys know what I should do to solve that issue? Thanks.

[naoyixue1]

Thanks Phil...See below.

In the right hand side, I caculated  a measure which indicate the rolling 28 days SKU consumptions %, naming 'Transaction %'. Now. I applied that trasaction % in SKU to break down the aggregated level forecast to the SKU level in bottles.  But I also need to show the forecast in case in below table in red. But just no idea how I can convert the forecast from bottle to case, based on the existing relationship in SKU lookup table. 

I tried to created a virtual table to include SKU, SKU bottle forecast and case to bottle relationship, but the SKU bottle level forecast doesn't show up.... might be there are the other ways for me to have the forecast in case....Thanks!

[PhilipTreacy]

Hi @naoyixue1 

Can you please supply your PBIX or at least some sample data and the code for your measures. Too hard to figure this out without any data to see.

Regards

Phil