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

Lookup value and circular dependency

HI all, 

 

Here's an issue with the following. 

 

I have one fact table that has a a one to many relationship to 3 dimension tables.

Obviously I have id to the fact table. 

 

I can create a hierarchy with the 3 identifiers and it does in the way I want. 

Then I try to create a hierarchy with the descriptor of the dimension but that does not fly. 

 

WHen I try to get the descriptors of the dimensions into the fact table with a lookup dax to create a hiearchy based on those descriptors I can only create one column on the first dimension and then when I try to create a second  column from the second dimension I get the error of <A circular Dependency was detected...).

 

1) Instead of trying to create the descriptor, is it possible to replace somehow the id description by its dimension descriptor?

 

Hope this is clear. 

 

Thanks


Francois

1 ACCEPTED SOLUTION
Anonymous
Not applicable

OK, I solved this by myself.

 

Instead of trying to use lookup, I used firstnonblank. 

 

This does the trick and I built my hierarchy with it. 

 

F

View solution in original post

1 REPLY 1
Anonymous
Not applicable

OK, I solved this by myself.

 

Instead of trying to use lookup, I used firstnonblank. 

 

This does the trick and I built my hierarchy with it. 

 

F

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.

Top Solution Authors