Sum per Type_Measure

[AllanBerces]

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

[vicky_ · Accepted solution]

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])
)

[AllanBerces]

Hi @vicky_ thank you very much for the reply