Inaccurate circular dependencies
Currently, the framework of Power BI throws circular dependency errors, but even in cases where it is not true. For example, let's say I have a table with three columns and two rows (A1, B1, C1, A2, B2, C2) where A is a fact value (eg. volume), B is a calculated volume and C is dependent on the calculation B. However, the calculation of B is the total of A and C for all rows whose index is before the current row.
Power BI views this is a circular dependency, because it is only looking at column references; not the row context.
I should be able to write the following in Column B without causing an error:
sum(A + C),
This type of idea works in Excel and in SQL. Without understanding where the breakdown is, but ideally there would be a function such as ALLBEFORE where it unfilters Fact_Table but only for the rows that are before the current index and no circular dependency is inferred.