cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
flahaye Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Highlighted
flahaye Frequent Visitor
Frequent Visitor

Re: Lookup value and circular dependency

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
Highlighted
flahaye Frequent Visitor
Frequent Visitor

Re: Lookup value and circular dependency

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 194 members 2,111 guests
Please welcome our newest community members: