Forum Discussion

dpbi's avatar
dpbi
Helper I
8 years ago
Solved

Circular Dependency

Hi all. I need some help with the following: A measure works fine when creating first calculated column. When i'm using similar measures (but not the same) for the second and the third calculated...
Need Help
  • dpbi's avatar
    dpbi
    8 years ago

    I used COUNTAX instead of COUNTROWS and it solved the problem.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi dpbi,

 

The short answer is: change the calculated columns by measures with the same code that you have and should work.

 

 

The long answer is very long, it is caused by the internal behavior of the calculated columns. In the following link you will find how to understand the circular dependencies and how to avoid them:
https://www.sqlbi.com/articles/understanding-circular-dependencies/

 

Regards.

  • dpbi's avatar
    dpbi
    Helper I
    8 years ago

    Hi Anonymous

    Thank you very much for your reply, but it doesn't solve the problem.

    I'm aware that i can drag the base columns and the measures to a visual and see the results, but it is not what i need.

     

    I need to have the results in calculated columns (since i need the results for each row). Only then  i can manipulate the data based on the results. The sample table, is a sample table with few rows where the real dataset is much bigger.

     

    I couldn't find a solution in the SQLB article you mentioned. My table is the only table and Iit is not part of a model. The table has only two columns. The 'Index' column has unique identifier (but maybe not in SQL terms).

     

    My sample table is the same as the source file (Excel). 

    Is there a way in DAX or Power Query to create these calculated columns?

    • dpbi's avatar
      dpbi
      Helper I
      8 years ago

      I used COUNTAX instead of COUNTROWS and it solved the problem.