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

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
Super User II
Super User II

@Melgaardiversen  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...

 




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


Proud to be a Super User!

Follow me here


Pragati11
Super User III
Super User III

Hi @Melgaardiversen ,

 

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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 @Melgaardiversen ,

 

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.