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.

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.