Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Credo
Helper I
Helper I

Relationship ambiguity with manager lookup

Hi 

 

I have a model that looks similar to this 

 

Manager.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I have a tricky situation with my Manager lookup because my account managers are not only responsible for a specific client but also for a specific SKU sold to that client. As a result, I need my Manager lookup table to be able to filter through both Dim Client and Dim Product in order to determine who is the manager for a specific Sale. 

 

The issue is that if I try to activate both relationships to the Dim tables I get ambiguity warning. I find that puzzling since all relationships are one way and flow towards the fact sales, so there should be no ambiguity. 

 

What are my options here? I need to be able to use the manager field for tables, charts, slicers with sales being filtered approprietly. 

3 REPLIES 3
LivioLanzo
Solution Sage
Solution Sage

Hi @Credo

 

You are getting the ambuiguity problem because the Sales table can be reached via the Manager > Clients > Sales path and via the Product > Sales path

 

The manager seems to be an attribute of Clients but als of Products.

Client A can have Mike as manager. Product A can have Mike as manager and Product B can have John as manager.

Client A can buy both Products A and B, therefore a Client assigned to Mike is buying one Product assigned to John and one Product assigned to Mike. 

 

If build something like this then you're allowed to see the sales of clients assigned to John but who have another manager for the products

 

 

 

2018-11-23_13-26-12.jpg

 

2018-11-23_13-28-45.jpg

 

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Unfortunately, that is not what I am looking for 

 

Such a solution would constantly limit me to a matrix visual if I wanted to graph data by manager as well as interfere with filtering behavior in my reports. 

 

I am hoping for some way to tie it all together and have a bar chart with sales by manager and drill through to client 

Why would you not be able to do that ?

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors