Solved: Circular dependency of dax tables

DataNinja777 · ‎09-18-2023

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 · ‎09-19-2023

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

View solution in original post

ERD · ‎09-19-2023

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

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Check out my latest demo report in the data story gallery.

Stand with Ukraine!

Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!

DataNinja777 · ‎09-19-2023

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 · ‎09-18-2023

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