Daily Sum

[AllanBerces]

Hi Good day,

Can anyone help me on how can i achieved my desired output. I need the sum of Daily Plan regardless of location. The Total Plan/day is the sum of Plan Hrs per planDate.

DESIRED OUTPUT

Thank you

[Khushidesai0109 · Accepted solution]

Hii @AllanBerces 
if you need it your way this can be done

Total Plan/day =
VAR TotalPerDay =
CALCULATE(
SUM('YourTable'[Plan Hrs]),
ALLEXCEPT('YourTable', 'YourTable'[PlanDate])
)

VAR FirstOccurrenceCheck =
RANKX(
FILTER('YourTable', 'YourTable'[PlanDate] = EARLIER('YourTable'[PlanDate])),
'YourTable'[Plan Hrs],
,
ASC,
DENSE
)

RETURN
IF(FirstOccurrenceCheck = 1, TotalPerDay, BLANK())



But the main thing to do it to create measure as it is more appropriate 
Total Plan/day =
CALCULATE(
SUM('YourTable'[Plan Hrs]),
ALLEXCEPT('YourTable', 'YourTable'[PlanDate])
)
Did I answer your question? Mark my post as a solution!
I'd appreciate the kuddos as well

[AllanBerces]

Hi @Khushidesai0109 thank you very much for the reply, working good.

[MattiaFratello]

Hi @AllanBerces, please use the following:

Total Plan Day =

CALCULATE(

    SUM('Table (2)'[Plan Hrs]),

    ALLEXCEPT('Table (2)', 'Table (2)'[PlanDate])

)

[ryan_mayu]

@AllanBerces 

you can try this

Column = CALCULATE(sum('Table (2)'[Plan Hrs]),ALLEXCEPT('Table (2)','Table (2)'[PlanDate]))

or create a measure

Measure = CALCULATE(sum('Table (2)'[Plan Hrs]),ALLEXCEPT('Table (2)','Table (2)'[PlanDate]))

[AllanBerces]

Hi @ryan_mayu @MattiaFratello thank you very much for the reply, is it possible the sum will appeared only once in each date, the same as my example for the calculated column.

Than you

[ryan_mayu]

that's not a good way to display data. you can create measure if you only want to see it once.

[AllanBerces]

Hi @ryan_mayu thank you very much, will check to change it to measure

[AllanBerces]