Get the highest value from selected date range

[nisansala23]

Hi,

I'm trying to get the highest value from a date range. below I have mentioned my dax code. it only returns the value related to slicer end date, not the highest value of the date range. Can anyone help me to figureout the issue

HIGHEST_ASPI_VAL =

var _year = SELECTEDVALUE('DATE'[YEAR])

var _yearstart = DATE(_year, 1, 1)

var _endDate = SELECTEDVALUE('DATE'[Date])

var ASPI_VAL = CALCULATE(MAX(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]),

    FILTER(BI_SECTOR_HISTORIES,BI_SECTOR_HISTORIES[SECTOR_DATE] >= _yearstart

        && BI_SECTOR_HISTORIES[SECTOR_DATE] <= _endDate))

var Result =

IF(

    NOT( ISBLANK(

        SUM(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]))),

        ASPI_VAL, BLANK())

        return

        Result

[BrianConnelly]

If you are trying to get the highest value within a selected date range, try using the Allselected...

var ASPI_VAL = CALCULATE(MAX(BI_SECTOR_HISTORIES[SECTORIAL_INDEX]),
  ALLSELECTED(BI_SECTOR_HISTORIES[SECTOR_DATE]))
      

[tamerj1]

Hi @nisansala23 
Please try

HIGHEST_ASPI_VAL =
MAXX (
    DATESYTD ( 'Date'[Date] ),
    CALCULATE ( MAX ( BI_SECTOR_HISTORIES[SECTORIAL_INDEX] ) )
)