Home › Forums › Power BI › Backward filters with M2M relationship in Power BI Tagged: powerbi filter m2m This topic contains 0 replies, has 1 voice, and was last updated by yacoubi 7 months, 3 weeks ago. Viewing 1 post (of 1 total) Author Posts November 27, 2018 at 10:15 pm #11247 yacoubiParticipant Started: 1Replies: 0Total: 1 I have been really struggling with this for the past week. Let me explain what is it that I’m trying to do and maybe you can help: A forecast is made for 1 product only. It has a date and volume to be ordered A product can have many forecasts Each product is made out of many intermediates (ingredients) using percentages totalling to 100%: Example: product A = 15% intermediate 1 + 45% intermediate 2 + 40% intermediate 3 How can I create a table or chart showing the following: monthly volumes for each intermediate (intermediate volume = product volume x intermediate percent for that product) Below is a snapshot of my current Power BI schema: https://i.ibb.co/C0cRnRt/schema.jpg Attachments:You must be logged in to view attached files. Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.