Max date is not working

[RAFIFFF]

Hi Team

i am using data range slicer in report

i need to clalculate sum of sales of max date of slicer like (30-09-2022)

CALCULATE(SUM(Query1[Gross Gen (incl NC Gen) Day - (MU)]),FILTER((Query1),Query1[Report Date]=[maxdate])) 

I tried by above dax by taking maxdate and add into filter .

but i am unable to get this max date sale.Can you please help.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I correctly understood your question, but please check the below measure whether it suits your requirement.

new measure: =
VAR _maxdate =
    MAX ( Query1[Report Date] )
RETURN
    CALCULATE (
        SUM ( Query1[Gross Gen (incl NC Gen) Day - (MU)] ),
        Query1[Report Date] = _maxdate
    )