topic Re: Circular dependency of dax tables in DAX Commands and Tips

Circular dependency of dax tables

DataNinja777 — Mon, 18 Sep 2023 13:54:04 GMT

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.

Re: Circular dependency of dax tables

some_bih — Mon, 18 Sep 2023 15:16:16 GMT

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

Re: Circular dependency of dax tables

DataNinja777 — Tue, 19 Sep 2023 04:36:19 GMT

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

Re: Circular dependency of dax tables

ERD — Tue, 19 Sep 2023 14:47:58 GMT

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] ) )) )

Re: Circular dependency of dax tables

DataNinja777 — Tue, 19 Sep 2023 15:27:26 GMT

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.