Creating a Relationship error - A circular dependency was detected

Power BI Data Model
1

Hey Guys, Thank you for your support!
I got this error when trying to create a relationship between tables with SK. ( Dimension with unique values and a Calculated table:
image

Calculated tables DAX:
Fact_Forecast_Days =
SELECTCOLUMNS(
FILTER( CROSSJOIN( ALLNOBLANKROW( Dim_Sensitivity), ALLNOBLANKROW( Dim_Dates)),
‘Dim_Sensitivity’[From Date] <= Dim_Dates[Date] &&
‘Dim_Sensitivity’[To Date]>= Dim_Dates[Date]),
“Active Date”, Dim_Dates[Date],
“Rate Type”, “Forecast Rate”,
“Ship Propulsion”, Dim_Sensitivity[Ship],
“Forcast Rate”, Dim_Sensitivity[Value],
“ShipSK”, Dim_Sensitivity[Dim_Ship_Granularity.ShipSK] )

the ALLNOBLANKROW was new for me, just did follow this “A circular dependency was detected”.

Can’t find any other reference for a solution.

Best Regards
Jose Milhazes

2

@JoseMilhazes Share sample PBIX.

1 Like
3

Hi @AntrikshSharma , let me see what I can do!

4

Hi Guys,

The relation I need to create is: Between ShipSK >> ShipSK

image
image491×771 25.7 KB

Under construction.pbix (2.3 MB)

Regards
Jose Milhazes

5

Bumping this post for more visibility.

6

Hi @JoseMilhazes! We noticed that your inquiry was left unsolved for quite some time now.

Looks like your inquiry was out of the experts and users’ bounds.

We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!

7

Hi All, did not find a solution to change the code on the table creation and then create the relationship. Actual did mimic in a new .pbix and did have any issue in creating the relationship. In order to solve my issue did create a virtual relation ship in my calculate column with TREATAS!

Thank you, for the effort
Jose Milhazes