Could you please assist with formula. I am trying to calculate sum of quantities of waste for specific date. I select to filter by date only but for whatever reason it also filters by product. Does anyone know how can I remove the filter on the product?
On example below I need new column to show "sum waste qty" for 18/12/2018 of 114, not 45.
How do you create the relationshiop between the two tables?
By my test, if you create the relationship betweent the two tables with Product ID, your formula should work.
Here is my test.
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)
Community Support Team _ Cherry Gao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.