cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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!

Cheers,

Alex

1 ACCEPTED SOLUTION
Frequent Visitor

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

Cheers,

Alex

5 REPLIES 5
Resident Rockstar

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.

Frequent Visitor

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

Cheers,

Alex

Resident Rockstar

Cheers 🙂 , Welcome

Community Champion

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

Proud to be a Super User!

Frequent Visitor

As a column!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors