A circular dependency was detected:

[msarfaraz]

I have table Name "Table of all Data" with 6 column field
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date TY[/TD]
[TD]Date LY[/TD]
[TD]Total Available Unit This Year[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="width: 150"]Total Sale Unit This Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="width: 181"]Total Available Unit Last Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Total Sale Unit This Year[/TD]
[/TR]
[TR]
[TD]01/01/2017[/TD]
[TD]01/01/2016[/TD]
[TD]500[/TD]
[TD]350[/TD]
[TD]600[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I creates New column This Year Sold Unit % by formula, LY occ % = calculate(Sum('Table of all data'[Total Sale Unit This Year]))/calculate(Sum('Table of all data'[Total available Unit This year]))
and its work fine but when I create another column by formula TY occ % = calculate(Sum('Table of all data'[Total Sale Unit Last Year]))/calculate(Sum('Table of all data'[Total available Unit Last year]))
I got error "A circular dependency was detected"

Any Help

 

[mole999]

on a normal sheet bottom left footer shows which cell has the circular reference, or at leaset the first one to rectify

 

[MarcelBeug]

on a normal sheet bottom left footer shows which cell has the circular reference, or at leaset the first one to rectify

Please note this is the "Power BI" forum; not the Excel forum. The formulas supplied are DAX formulas.

 

[anvg]

Hi
I am sorry, but I do not uderstand why you used calculate function in a calcualtion column? I think its result is equal simple formula
Instead

[COLOR=#333333]This Year Sold Unit % by formula, LY occ % = calculate(Sum('Table of all data'[Total Sale Unit This Year]))/calculate(Sum('Table of all data'[Total available Unit This year]))[/COLOR]

Use

=[COLOR=#333333]'Table of all data'[Total Sale Unit This Year] / [/COLOR][COLOR=#333333]'Table of all data'[Total available Unit This year][/COLOR]

In row calculation context of table they are equal.
Regards,