Forum Discussion

Powerbi1979's avatar
Powerbi1979
New Member
3 years ago
Solved

Ambiguous Relationship - Best Practices

Hi,   From a data modelling perspective, what is the perferred best practices solution to the following situation? In this case, the Organization dimension exists on both Employees and Projects, an...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    Powerbi1979 , As there are two paths to fact you can not join.

     

    Two option

    1. keep it independent and filter measure and slicer using the selected values

    Slicer  filter example

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

    You also need make sure all measures get filtered 

     

    2. Merge it with both dimensions in the power query. but that will not give common filter

amitchandak's avatar
amitchandak
Super User
3 years ago

Powerbi1979 , As there are two paths to fact you can not join.

 

Two option

1. keep it independent and filter measure and slicer using the selected values

Slicer  filter example

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

You also need make sure all measures get filtered 

 

2. Merge it with both dimensions in the power query. but that will not give common filter