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

Circular dependency

Hi

I am trying to make a new column and it works perfectly, but when I copy the dax to make another column (almost the same column), I meet an error message "Circular Dependency was detected".

The function for the column that works: 

 
 

1.PNG

The same dax function for a new column gives me the below error:
 
 
 

Capture.PNG 

 

How can that be possible? it is the same dax function?

Best regards

Rune 

4 REPLIES 4
negi007
Community Champion
Community Champion

@Anonymous  Have you tried to explore below articles to understand the reason behind circular dependency

 

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

 

https://community.powerbi.com/t5/Desktop/quot-A-circular-Dependency-was-detected-quot-error-while/td-p/170560

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Pragati11
Super User
Super User

Hi @Anonymous ,

 

Circular dependency error occurs when you are trying to create calculated columns in your dataset. Here you are trying to create nearly same column which is already there.

I would suggest creating a measure rather tan a column.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

HI

I need to be able to slice on the "kuranskode". The function returns 1,2,3,4 or 5. If I make to a measure, I can't put it in a slicer.

BR


Hi @Anonymous ,

 

There is a workaround to use a Measure as a slicer in Power BI. Refer following blog:

https://www.fourmoo.com/2018/07/10/creating-a-slicer-that-also-contains-a-dax-measure/

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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.