Forum Discussion
Information Display in a table
Hi Anonymous
first of all implenting a star schema with bi-directional filter is rarely a good idea. TO build a cleaner model you should merge ANZ and Africa table in Power Query upfront. There is a high probabily that also your challenge will be solved by that.
Best regards
Michael
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
-----------------------------------------------------
Solution SageHi Anonymous ,
please first study the fundamental importance of a star schema data model.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
You don´t need to use many to many relationships, instead only 1 to many relationships.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.