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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Ambiguous paths in conception

Hello ! 

 

I currently have a Sales fact table I can analyse through by many axis, among which Date and Country, but I want to add an axis that would allow me to analyze the sales depending on the Marketing Campaign that was running when and where the sale was made.

 

Here's the conception I currently have : 

NossairR_0-1626691983577.png

 

 

But I get an error message telling me that there are ambiguous paths between Marketing Campaign and my Sales table. I can see why, but I can't quite figure out how I could solve this without directly linking it with my fact table (which I'm trying to avoid since this is a simplified version and in reality I'd have to modify 10 different fact tables to link them).

Is there any way I can achieve this conception ? I currently have a many to one link between MC and Country/Date (filter on both tables), as well as a many to one link between Sales and Country/Date (filter on Sales).

 

Thanks in advance,

Nossair

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Make sure joins are single direction 1- M from Date or Country to Sales or Marketing Campaign.

 

Bi-Directional join's can create a loop, hence this error

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Make sure joins are single direction 1- M from Date or Country to Sales or Marketing Campaign.

 

Bi-Directional join's can create a loop, hence this error

Anonymous
Not applicable

Hi @amitchandak ,

 

When you're talking about 1-N / bidirectional, are you talking about the cardinality of the relationship or the direction of the filter ?

 

Thanks,

Nossair

 

Hi @Anonymous 

"1- M" ——> one to many😃, i.e.  the cardinality of the relationship

-

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution. so the others can find it more quickly. thanks

 

Any question, please let me know. Looking forward to receiving your reply.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.