A circular dependency was detected:

[msarfaraz]

I have table Name "Table of all Data" with 6 column field

Date TY	Date LY	Total Available Unit This Year	Total Sale Unit This Year <tbody> </tbody>	Total Available Unit Last Year <tbody> </tbody>	Total Sale Unit This Year
01/01/2017	01/01/2016	500	350	600	400

<tbody>
</tbody>

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,