Information Display in a table

[Anonymous]

Hi All

Hope you guys can help

I have a code for the countries which I want to surface in a table in PBX.

However, when I choose to display it, it only displays values for Africa and Not for Oceania region despite tables being linked via countries list

The linkage looks as below:

"Global Location Ref" is used as a table Country on the image above (and all tables are linked via countries)

Any hel will be greatly appriciated 

[mangaus1111]

Hi @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.

[Mikelytics · Accepted solution]

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.

-----------------------------------------------------

LinkedIn

[Anonymous]

Thank you!