Forum Discussion
Solved
Syntax for Sum filters
Am trying to filter one table with data from another related table but the syntax is beating me... new utilisation = FORMAT(DIVIDE(SUM('time_entries'[hours]), FILTER(ALLSELECTED(tasks),'tasks'[task n...
sputnik76 do you mean :
new utilisation = DIVIDE(CALCULATE(SUM('time_entries'[hours]), 'tasks'[task name] <> "On Leave"), [Max Possible Hours], 0)Please try.
Aiolos Zhao
Nearly works. If I want to make filter for everything EXCEPT 'On leave, how would I achieve that?
sputnik76 do you mean :
new utilisation = DIVIDE(CALCULATE(SUM('time_entries'[hours]), 'tasks'[task name] <> "On Leave"), [Max Possible Hours], 0)Please try.
Aiolos Zhao