Calculated Column / Measure not working with date filters

[JDSang]

Hi

i'm trying to show employee time vs total team time.

I'm able to work out the total time logged by a team, but when I apply a date selection (via slicer) it does not update the calculation. the below table shows Team and the amount of time logged (left), and employee time vs team (right). the date slicer is set to 2021, which is reflected in the left columns and the "employee time" column, however the "Team Total" column should be the same as the "Team Time for Period" column

Current Year				Current Year	Total
Team	Team time for period		Team	Employee	Emp loyee Time	Team Total
Team1	23,204.50		Team 1	Emp 1	493.08	129,247.00
Team2	20,676.00		Team 1	Emp 2	376.75	129,247.00
Team3	1,226.83		Team 1	Emp 3	574.83	129,247.00

I have tried 

Measure = CALCULATE(SUM('Time'[Time Logged]), ALLEXCEPT('Time', 'Time'[Team]))

Column = CALCULATE(SUM('Time'[Time Logged]), FILTER('Time', 'Time'[Team] = EARLIER('Time', 'Time'[Team])) and various variations of this.

but no matter what i try I cannot get the team total to line up. can someone please help?

Thanks in advance

James

[JDSang · Accepted solution]

I got this to work...

Created a Measure to work out time logged by individual, another measure to work out team total:

Team Measure = CALCULATE([Individual Time], REMOVEFILTERS('Table'), VALUES('Table'[Team], VALUES('Date Table'))