Forum Discussion
Solved
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 ...
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
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