Hi all,
I have the following tables. The tables on the left are being used for filtering purposes and they are linked with the rest of the tables with '1 to many' relationships
| Filters | | | | Historical Data |
| | | | | | | |
| Calendar Table | | | | Daily stock status | | Orders breakdown |
| Date | | | | Date | | Date |
| Day | | | | SKU | | SKU |
| month | | | | Site Id | | Site Id |
| quarter | | | | Shipments | | Units Ordered |
| | | | | Receipts | | Order number |
| | | | | Bridge (Site, SKU, Date) | | Bridge (Site, SKU, Date) |
| | | | | | | |
| | | | | | | |
| SKU Table | | | | | | |
| SKU | | | | | | |
| Description | | | | | | |
| | | | | |
| | | | | | | |
| Site Table | | | | Forecast | | Goods In |
| Site name | | | | Day | | Site Id |
| Site Id | | | | Site Id | | SKU |
| Region | | | | SKU | | QTY Due in |
| | | | | Demand | | Expected date |
'Daily stock status' - a report providing snapshot of the day. Summarises all transactions by Date, SKU, Site
'Orders breakdown' - a report providing all orders
both of the above are historical data
**** I couldn't filter appropriately these two for some reason so created a bridge with a '1 to many' relationship starting from 'Daily stock status' ****
'Forecast' and 'Goods In' are both reports with one week's worth of data and i am really interested on the totals.
What i am trying to do is create a table on the report view that will take into consideration the applied filters (Normally supplier, SKU, site) and provide the summarised information, with the intention to create a calculated measure that will highlight how many units do i need to order to meet the demand for the next week.
| Site | SKU | DESCRIPTION | Units Ordered average per Week | REC_RETURNS average per Week | SH_CLOSE on last update | QTY Due in | Forecasted demand |
| x | 0001 | SKU_0001 | 10 | 3 | 1 | 87 | 61,748 |
Although the 'SKU table' and 'Site table' are connected with '1 to many' relationships with the 'Goods In' and 'Forecast' the values are not filtered and i get the total sum of the tables (Bold on the table)
I am fresh on PowerBI reporting so hope the abovemake sense. I normally find the solutions to my problems from the already provided threads, however in this case i am hitting a dead end. Any help is appreaciated.
Thank you
