Data source errorA circular dependency was detected

Thanks for DallasBaba's concern about this issue.

Hi, SSBkrish 

This error is usually caused by two or more columns or tables referencing each other, a circular dependency that prevents Power BI from processing the data.

As DallasBaba  said, Measure evaluates reports based on their context and does not create dependencies in the data model. If you have calculated columns that reference each other, you can use a metric value instead of a calculated column.

If you use CALCULATE in a calculated column, it may also cause a context switch, which can cause a circular dependency. You can use ALLEXCEPT or REMOVEFILTERS to limit the columns on which a calculated column depends.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.