I have a Warehouse table which holds current values of BOM-component stockcodes. I have the Warehouse values (eg On Hand) as rows on the pivot (so that they can be nested under their respective parents from the sales data), but I need to operate on them as values, and I'm struggling to build a measure for the On Hand qty. I can't seem to get the filtering and/or relationships (and/or crossfiltering) right. I thought I could wrap a Calculate around the sum of On Hand inside Calculate, and that that would force the current row context into a filter context. But the result (the [On Hand Qty BAD] measure under Warehouse) lacks filter and returns everything. (I'm trying to avoid calculated columns on the source data.)
There are too many tables and relationships to paste everything in here but I have the xlsx file shared here: https://1drv.ms/x/s!Aq0xcVjtciftgVsCQGSUGlhliDQx?e=fINfiK
Hoping someone might explain how this could be handled?
