Forum Discussion
Solved
Calculated Column / Measure not working with date filters
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...
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'))
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'))