Forum Discussion
Circular Dependency
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
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
5 Replies
As a column!
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.
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
Cheers :-) , Welcome
