Circular Dependency

[alexadams78]

Hi All,

This is probably a simple issue, but i'm having a nightmare with a simple Calculate(Sum formula.

Using 1 table containing timesheet data, I have column for Hours Worked. I've managed to successfully create a formula which calculates the sum of hours worked, where a certain client ID isn't present:

Non-Jupiter Hours = CALCULATE(SUM(Timesheet[HOURS_WORKED]),'Timesheet'[CLIENT] <> "www.Jupiter.com")

I'm trying to write the converse of that to show ONLY Jupiter hours:

Jupiter Hours = CALCULATE(SUM(Timesheet[HOURS_WORKED]),'Timesheet'[CLIENT] = "www.Jupiter.com")

And this is where I get the circular dependancy issue. I would understand if I'm referencing other calculated columns in either formula, but I'm not!

Can someone please help?

Cheers,

Alex

[Baskar]

Hi @alexadams78

Jupiter Hours = CALCULATE(    SUM(Timesheet[HOURS_WORKED]),
                                                  Filter(Timesheet, 'Timesheet'[CLIENT] = "www.Jupiter.com")
)

Try this one , Let me know if it is not helping u.

[alexadams78 · Accepted solution]

Hi Baskar,

I actually tried this forumla before but as a calculated column. I just tried it as a calculated measure, and it worked!

Amazing, thanks for your help!

Cheers,

Alex

[Baskar]

Cheers 🙂 , Welcome 

[Anonymous]

Are you adding this as a calculated column or as a measure?

[alexadams78]

As a column!