Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Circular Dependency within Table for calculated column

Hi there,   I've been tyring to correct a circular dependency between two calculated columns and I can't seem to find the answer.   I have one table that I am using for the calculations, there ar...
Need Help
Chihiro's avatar
Chihiro
Icon for Solution Sage rankSolution Sage
7 years ago

Without sample data, hard to help you. I'd recommend uploading pbix with sample model (using dummy data, but with same structure) to OneDrive or some other service and share a link here.

 

It makes it so much easier to help you, when we don't have to recreate/imagine the model you are working with.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Any idea on how to solve this?

  • Chihiro's avatar
    Chihiro
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Try using it as measure instead of calculated column.

     

    With your sample it returns Group1 for all but the last row (which shows Other as MarginClass & MarginPL show NaN).

     

    Not sure if this is correct result or not.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I can't use measures since I need to use these groups as a visualization axis. 

      • Chihiro's avatar
        Chihiro
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Normally, I'd do bucketing and categorizing in Query Editor stage then.

         

        I'll have to go through your file more in detail to follow all the steps and criteria applied. Will see if I have time tomorrow or later in the week.