Circular dependency of dax tables

[DataNinja777]

Hi,

I occasionary encounter circular dependency issues when trying to create relationships between tables created using dax table functions and the dimension tables (such as calendar table etc.,)  

I attach the link to the pbix file which is generating the error message above. 

Price index.pbix

I'd greatly appreciate it if anyone could let me know if there is a quick fix to this circular dependency issue.  

[ERD · Accepted solution]

@DataNinja777 , you need to create your second table in a bit different way:

Summary = 
ADDCOLUMNS(
SUMMARIZE ( 'Table',
    'Table'[Item Code],
    'Calendar'[yyyy-mm]),
    "Price", CALCULATE(DIVIDE ( SUM ( 'Table'[Value] ), SUM ( 'Table'[Qty] ) ))
)

[DataNinja777]

Thanks!  The circular dependency error message disappeared, although it transpired that there was another underlying issue of many-to-many relationship when trying to create a relationship with the calendar table.  

[DataNinja777]

Hi,

Regarding the circular dependency issue, sometimes removing the blanks in the calculated table helps, but this time, it didn't.  How do you fix this circular dependency issue of the calculated table?  

Price index.pbix

[some_bih]

Hi @DataNinja777 your Calendar table is not correctly created, ADDCOLUMNS part. check it