Circular reference issues

Anonymous — Wed, 05 Dec 2018 11:02:13 GMT

Hi BI community,

I am new to PowerBi and are trying to create a financial dashboard for a compay.

I have created 2 tables, one quering from a SQL database and 1 with the budget imported. I've then created a unique ID containing the region of sales and the first date of the month for each of these tables and made a relation.

First, I've done a lookup value to import the Budgetted units

BudgetUnits = LOOKUPVALUE(SwedenBudget[Units];SwedenBudget[UniqueID];SwedenSales[UniqueID])

Now, I've been trying to the same for revenue (located in the next column in the budget table).

BudgetRevenue = LOOKUPVALUE(SwedenBudget[Revenue];SwedenBudget[UniqueID];SwedenSales[UniqueID])

I am getting the following error:

"A circular dependency was detected: SwedenSales[#BudgetRevenue], SwedenSales[#BudgetUnits], SwedenSales[#BudgetRevenue].".

I do not understand this, as none of them are dependent on each other? Can anyone help?

Thanks,

Rasmus

Re: Circular reference issues

v-chuncz-msft — Thu, 06 Dec 2018 09:56:12 GMT

Anonymous,

This might be caused by Cross filter direction. You may use RELATED instead.

topic Re: Circular reference issues in Developer

Circular reference issues

Re: Circular reference issues