Relationship¶

dotted relationship line¶

inactive relationship

ambiguous relationship¶

https://cloudbi.com.au/how-to-manage-ambiguous-relationship-in-power-bi/

three tables: Tab-Customer-Country, Tab-Customer, Tab-Sales

circular table: by creating a reference dim table (Tab-Sales-Country) and duplicate the slicer so we have two synchronized clicers:

• one for customer (customer-country)

• another for sales (sales country)