Total market based on marketshare calculation

[Arundo]

Good afternoon, 

New to Power BI, getting far but not far enough. So therefor I would like to check if the below is possible. First of all I have two data sheets. Data 1 with sellout of many different customers per product / productgroup / month / quarter / year. Data 2 with our marketshare per customer per productgroup / month / quarter / year. 

Based on this I can create an overview of Customer X with a sellout of 100 per productgroup A. The same customer X has 25% marketshare in this productgroup A. Now I want to calculate the total available market within customer X based on productgroup A. The answer should give 400 but i'm not getting the measure to work this out. 

Furthermore I would also like to make relationships between Data 1 and Data 2 so I can make one table showing per month sellout customer X, Share customer X and Total available market customer X. I should be able to get for customer X the share and sell out per month but as below picture the sellout gives the same number every month. The relationship is many to many (cant select another one) and both. 

Thanks for the help in advance with these questions. 

So pictures to illustrate. 

[dax]

Hi Arundo, 

If possible, could you please inform me more detailed information(such as your sample data and your expected output or your pbix file)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.