cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jessica_Seiya Solution Sage
Solution Sage

Circular dependency was detected when use Calculated+Firstnonblank

Hi Experts,

 

Hope somone could help me understand this circular dependency error. I'm running a test, the table blelow is very simple, only have two columns: ID is number, and Time is datetime. I created a calcuated column named First_Time using Calcuate function. The problem I could not understand is that why when the Firstnonblank refers to the time (datetime type) column itself, the circular dependency error would happened, but when it refers to a specific date('time'.[day]), the error disappeared.

 

The DAX First_Time might meaningless, but I really want to understand how Calcuate and Firstnonblank works in this situation.

 

Thanks in advance

WX20180424-222848.png

 

WX20180424-222924.png

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Circular dependency was detected when use Calculated+Firstnonblank

HI @Jessica_Seiya,

 

I think this issue may related to time intelligence feature.

 

AFAIK, time intelligence will generate a hidden calendar table based on date/time column to expand hierarchy tree for this column.

 

Firstnonblank function will also loop through current table, so I think it's calculate logic may conflict with hidden calendar table generate, so power bi shows circular dependency error.

 

In addition, you can also take a look at below link which told about circular dependency issue:

Understanding Circular Dependencies in Tabular and PowerPivot

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Circular dependency was detected when use Calculated+Firstnonblank

HI @Jessica_Seiya,

 

I think this issue may related to time intelligence feature.

 

AFAIK, time intelligence will generate a hidden calendar table based on date/time column to expand hierarchy tree for this column.

 

Firstnonblank function will also loop through current table, so I think it's calculate logic may conflict with hidden calendar table generate, so power bi shows circular dependency error.

 

In addition, you can also take a look at below link which told about circular dependency issue:

Understanding Circular Dependencies in Tabular and PowerPivot

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Jessica_Seiya Solution Sage
Solution Sage

Re: Circular dependency was detected when use Calculated+Firstnonblank

Hi Xiaoxin, Thanks a lot for your help. If the date/time column is a calendar table in the backend, it would make sense to explain this circular dependency issue.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors