Forum Discussion

sputnik76's avatar
sputnik76
Frequent Visitor
7 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

sputnik76's avatar
sputnik76
Frequent Visitor
7 years ago

Great thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    sputnik76 

    I'm glad to help you, if my answer is correct, could you please mark it as "accepted solution"?

     

    Thanks.

    Aiolos Zhao