cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kaushikmakadia
Helper I
Helper I

Analysis Service Tabular Model there are ambigous path relationship

Hi there,

I have below tabular model SSAS relationship in data model :

ActionTable [ActionDate] with M:1 with CalenderDate[FullDate]

TicketTable[TicketReportDate] with M:1 with CalenderDate[FullDate]

 

CalenderTable

FullDate

 

ActionTable

ActionID

TicketID

ActionDate

 

TicketTable

TicketID

TicketReportDate

 

But when I try to add new relationship ActionTable[TicketID] M:1 with TicketTable[TicketID] it says there are ambigous path between 'ActionTable' and 'CalenderTable': 'ActionTable' --> 'CalenderTable' and 'ActionTable'->'TicketTable'->'CalenderTable'

 

please help?

 

This is in Visual Studio SSAS tabular project.

5 REPLIES 5
amitchandak
Super User IV
Super User IV

@kaushikmakadia , Please create a common ticket Table. As both are already joined with Calendar in 1-M and now consider as facts. If the ticket is both fact and dimension. Take one more copy of the ticket and use that as a dimension , do no join with date



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks Amit. Can you please more details wih mutiple solution step. Sorry jus wasnt clear in response, thats all. Cheers

@kaushikmakadia , As Both Ticket and Action, are Fact. If you need to join Ticket and Action then you need to have a common ticket table. That comes from distinct values from both table.

But If Ticket to Action is 1 -M, means the ticket is also dimension, as well as fact. Add Ticket again  with a new(Ticket_dim)  name and use it only to connect with  Ticket and  Action(1 - M)



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thank you so much Amit. Will check it out

Hi, @kaushikmakadia 

Could you please tell me whether your problem has been solved?

If yes, you could accept the helpful answer as solution. You could also share your own solution here.
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors