Circular Dependency while creating a Column even if using different fields.

[elmurat]

Hello,

I have a Circular Dependency error in my column calculations despite using completely different fields.

When I have a measure, I don't have this error. But  I need to create a column because I need to use it in a slicer.

Does anybody know how to fix this?

Here is a link to pbix file.

[Anonymous]

Hi @elmurat,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Thank you,
Pavan.

[Anonymous]

Hi @elmurat,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @elmurat,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Deku]

If you define the measures logic in the field you don't get the circular reference error

40-Day % Categories CLMN = 
VAR A = 
DIVIDE(
    SUM(Sheet1[Actuals_40])-SUM(Sheet1[31_60]),
    SUM(Sheet1[Actuals_40])
)

RETURN
    IF(A>.70,"1. Above 70%",
    IF(A<.50,"3. Below 50%","2. Between 50% and 70%")
    )

[elmurat]

But I cannot use the measure as a Slicer.

[Deku]

Yes, that is why the field for the slicer has all of the logic for it's creation self contained, without the reference to the measure.

[elmurat]

I got what you mean, and I have already tried it, but when I make the column logic self-contained, the result is not right. Please see the 10-Day% Categories CLMN in the screenshot below.

[Anonymous · Accepted solution]

Hi @elmurat,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Deku  for the helpful response.

Please follow below steps to resolve the error;

1.Make sure the calculated column works correctly at the row level, without relying on aggregation or filter context that only applies to measures.

2.If the calculation needs values from other rows or tables, use RELATED or LOOKUPVALUE to fetch related data for the column.

3.Modify the column logic to perform row-wise calculations, ensuring it works independently for each row:

10-Day % Categories Column = 

VAR Percentage = DIVIDE(Sheet1[Actuals_10] - Sheet1[OtherColumn], Sheet1[Actuals_10])

RETURN 

    IF(Percentage > 0.70, "Above 70%",

    IF(Percentage < 0.50, "Below 50%", "Between 50% and 70%"))

4.Make sure the fields used in the calculation are numeric and compatible for division.

Please continue using Microsoft Community Forum.

If this post helps in  resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,

Pavan.

[elmurat]

@lbendlin @Ritaf1983 @danextian @bhanu_gautam @pankajnamekar25  please help, if you can.