3M_Y2 = CALCULATE([1M_Filtered],all(Dates),USERELATIONSHIP(Comparision_Dates[Datekey],Sales_Combined[Completed Date]),DATESINPERIOD(Comparision_Dates[Datekey],ENDOFMONTH(DATEADD(Comparision_Dates[Datekey],0,MONTH)),-3,MONTH))
Now I want to use union and summarize to upviot these measures into one column.
So it could be like
Year ,Month ,Location ,Category, Measures ,Values
2023,Jun, AG, WHS, 1M, 2575
2023,Jun, AG, WHS, 1M_Y2, 2766
2023,Jun, AG, WHS, 1M_YvY, -6.91%
2023,Jun, AG, WHS, 3M, 9564
2023,Jun, AG, WHS, 3M_YvY, -17.92
However, there is a circular depencey detected When I use this formula:
test_table2 = UNION(SUMMARIZE(Sales_Combined,Dates[Year],Sales_Combined[Completed Date],Month_All[Month],Sales_Combined[Category],Sales_Combined[Type],Sales_Combined[Manufacturer],"Measures","1M_Filtered","Values",Measures_1[1M_Y2 ]))
The error message is like this

I know generally what circular dependency is, but I still can not solve this issue. I can not get around using Sales_Combined[Completed Date] this column. anyhelp?