Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Sum per Type_Measure

Hi good day,

Can anyone help me on my measure. from my table i want the sum per type per plan date. When i used my meaure i dont get the result i need. pls correct my measure.

 

Plan_day =
CALCULATE(
SUM('Table'[Plan Hrs]),
ALLEXCEPT('Table', 'Table'[PlanDate])
)
 

DESIRED OUTPUT

 

Thank you

Need Help
  • vicky_'s avatar
    vicky_
    1 year ago

    You're 99% of the way there - just need to add your type back into the ALLEXCEPT part:

    Plan_day =
CALCULATE(
SUM('Table'[Plan Hrs]),
ALLEXCEPT('Table', 'Table'[PlanDate], 'Table'[Type])
)

    btw - not sure what the rest of your data and requirements look like, but you could also rewrite the above as:

    Plan_day =
CALCULATE(
SUM('Table'[Plan Hrs]),
REMOVEFILTERS('Table'[Trade])
)

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    1 year ago

    You're 99% of the way there - just need to add your type back into the ALLEXCEPT part:

    Plan_day =
CALCULATE(
SUM('Table'[Plan Hrs]),
ALLEXCEPT('Table', 'Table'[PlanDate], 'Table'[Type])
)

    btw - not sure what the rest of your data and requirements look like, but you could also rewrite the above as:

    Plan_day =
CALCULATE(
SUM('Table'[Plan Hrs]),
REMOVEFILTERS('Table'[Trade])
)