Problem with ring dependency

[Anonymous]

Hello everyone, I have a question regarding a Power BI problem and I hope I can find some help in this forum. It's about the error message "Ring dependency":

In one column I want Certain FTE per Sector. This would be calculated like this: Actual FTE of a Sector + Future Hires of a Sector + known leavers of a Sector = Certain FTE of a Sector

In BI, this formula looks like this: certain FTE per sector = calculate (sum([Latest FTE Number (Actuals)]) + sum([Future Hires]) + sum([Contracts Sent])+ sum([Offer Sent]) - sum([Leaver FTE Latest] ), FILTER(' Sector Mapping', [Sector] = Sector Mapping'[Sector]), 'Calendar'[Future Date] = True())

This formula works, values ​​come out.

Now I also want to calculate the Expected FTE per Sector, which is really just Certain FTE per Sector + Open Positions per Sector.

I use the following formula: expected fte per sector = calculate(sum([certain FTE per sector])+sum([Open Positions])

This doesn't work, I get the error message "ring dependency".

The ring dependency cannot be in the open positions, these can be displayed "alone". And the Certain FTE per Sector can also be viewed “alone”.

Why is it not possible to combine both columns?

I would be really grateful for help.

[v-yanjiang-msft]

Hi @Anonymous ,

Could you please provide the error snapshot here, haven't seen the same error before.

Best Regards,
Community Support Team _ kalyj