Circular dependency

[Anonymous]

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: 

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

 

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

Best regards

Rune 

[negi007]

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

[Pragati11]

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

[Anonymous]

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

[Pragati11]

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