Forum Discussion

elmurat's avatar
elmurat
Advocate I
1 year ago
Solved

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

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago
    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.

     

9 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    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's avatar
      elmurat
      Advocate I
      1 year ago

      But I cannot use the measure as a Slicer.

      • Deku's avatar
        Deku
        Super User
        1 year ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
    Anonymous
    Not applicable
    1 year ago

    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.