Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
Solved! Go to Solution.
@Anonymous , I have done some changes, Created a combined key, and joined with those.
Please find the file after signature
@Anonymous , I have done some changes, Created a combined key, and joined with those.
Please find the file after signature
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |