How to display the correct values using the dimension table in a many to many relationship

[Anonymous]

Hello 

I would like to merge 2 facts tables and display a clustered colomun chart. 

In this case a product can belong to mutiple markts (many to many relationship )

When I filter the chart using the market id from the fact table, I get the wanted behaviour as shown as seen below 

However, when i use the market_cd from the dimension table, i get the following result

The 2020 june-July period for the product S, shouldn't be displayed however it is showen because of the many to many relationship. 

I there a way to create a measure that will fix this problem and allow me to display the correct info while filtering the information with the market_cd from the dimension table ?

I have inclueded a sample data

https://drive.google.com/file/d/1uOROUu_0g8mgc8OMJhyiflFD1wAnaGNW/view?usp=sharing

Thank you for your help,

Mariem,

[amitchandak · Accepted solution]

@Anonymous , I have done some changes, Created a combined key, and joined with those.

Please find the file after signature