cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Domenick
Helper III
Helper III

Relationships introduce "ambiguity" - How can I chart values from these different tables.

I'm trying to chart actual versus planned spend on a chart like this:

Domenick_0-1619557564714.png

Planned hours/spend are stored in one table while actual hours/spend are stored in another. Project data is stored in an independent table, and I have a calendar table that I can use (not all dates exist in either planned or actual tables). 

Planned vs Actual troubleshooting.PNG

I've tried joining the Planned and Actual tables to Projects on P_Number and the Planned and Actual tables to Calendar on Date. This seemed to make sense to me in order to show all figures on the same chart in proper chronology. But I get an error when I do so, saying that I'm introducing ambiguity:

 

Domenick_1-1619557820861.png

 

Can someone help me figure out the proper relationships so that I can make these tables play nicely and build the chart above?

4 REPLIES 4
yingyinr
Community Support
Community Support

Hi @Domenick ,

You can refer the solution in the following links to resolve it:

How to manage ambiguous relationship in Power BI

Bidirectional relationships and ambiguity in DAX

Ambiguity relationship

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dnerada
Post Patron
Post Patron

One more question where does the information for the line contract in your graph come from? 

Dnerada
Post Patron
Post Patron

So just to confirm I understand you connected Calendar table date to both planned and actual hours date and then you connected projects p_number to both planned and actual p_number. 

One thing to make sure that the calendar table is not connected to the project table and that each relationship is a one way from dimensional table to each the budget and actual. 

That should work 

Ashish_Mathur
Super User III
Super User III

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors