I have tried different modeling techniques, first I tried a bridge table between historical orders (received pivot) and future orders, and I used bi-directional filters, which resulted in incorrect quantities exploded in the visual. Next, I tried a many-to-many relationship between the historical orders and future orders table, and still the measures I'm trying to calculate off the future orders table do not calculate properly. For example, my future orders table shows 830,000 items on future orders Oct-Dec, but if I sum the future order quantity I get over 66 million per month...which is absolutely incorrect.
Will someone please help?
Future Orders quantity for October are correctly loaded into Power BI Desktop, and should total 830,000.