Hi @arvindyadav ,
We can create a measure as sum to meet your requirement.
VAR t =
CALCULATE ( MAX ( 'Table'[Date] ), ALLSELECTED ( 'Table' ) )
HASONEVALUE ( 'Table'[Date] ),
SUM ( 'Table'[Vaule] ),
CALCULATE ( SUM ( 'Table'[Vaule] ), FILTER ( 'Table', [Date] = t ) )
If it doesn't meet your requirement, Please show the exact expected result based on the Tables that We have shared.
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.