How can we improve Power BI?

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:

Calculate(
sum(A + C),
filter(
all(Fact_Table),Fact_Table[Row_Index]<
earlier(Fact_Table[Row_Index])
)
)

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.

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Shawn Prodgers shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.