Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Are you adding this as a calculated column or as a measure?
Proud to be a Super User!
As a column!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |