Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Circular dependency issue

  Hi,   I'm trying to build a table in Power BI which includes a rolling sum columns, but i have an issue of circular dependency. I can build it in excel woth no problem.         The ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks,

    I implemeted it with Power Query iventually, using function to get the running total and then use it in User1Pct and User2Pct.

     

     

    Regards,

    Eran

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

Hi Anonymous,

I got it. The first row of User1Pct is 1, User2Pct is 0. you calculated other rows based on the first row. The basic unit is the cell. But in Power BI we calculate based on column instead of cell or row.

At first, I thought I can set User1Pct=1, User2Pct=0, then create calculated columns.

User1 = IF(OR(Table1[User]="Both",Table1[User]="User1"),Table1[Cashflow]/Table1[Price]*2230.05*IF(Table1[User]="Both",Table1[User1Pct],1),0)

 

User2 = IF(OR(Table1[User]="Both",Table1[User]="User2"),Table1[Cashflow]/Table1[Price]*2230.05*IF(Table1[User]="Both",Table1[User2Pct],1),0)




Then I try to fix User1Pct and User2Pct, we can't get expected result, which caused by Circular dependency issue. The basic unit in Power BI is column. So you'd better get expected result in excel, then can upload the result to Power BI desktop.



Best Regards,
Angelia

Best Regards,
Angelia

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks,

I implemeted it with Power Query iventually, using function to get the running total and then use it in User1Pct and User2Pct.

 

 

Regards,

Eran

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Congratulations, you have resolved your issue by yourself. Please mark the right reply as answer, or welcome to share your detailed workaround, so that more people will benefit from here.

    Best Regards,
    Angelia