LIMIT DATA SET IN IF FUNCTION USING DAX

[desbarden]

Below DAX Function returns all the data in the dataset . How can I limit it to the IF conditions stated ?

Trial =

VAR _kpi = CALCULATE(SUM('RAN AH'[Daily]),'Date'[Date] = SELECTEDVALUE('DAY'[Time]))

VAR _allowed_dates = {MAX('Date'[Date]), MAX('Date'[Date]) - 1, MAX('Date'[Date]) -7, TODAY()}

RETURN

        IF(SELECTEDVALUE('DAY'[Time]) IN _allowed_dates, _kpi , BLANK())

[FreemanZ]

hi @desbarden 

try like:

Trial =

VAR _kpi = CALCULATE(SUM('RAN AH'[Daily]),'Date'[Date] = SELECTEDVALUE('DAY'[Time]))

VAR _max = MAXX(ALL('Date'[Date]), 'Date'[Date])

VAR _allowed_dates = {_max, _max - 1, _max -7, TODAY()}

RETURN

        IF(SELECTEDVALUE('DAY'[Time]) IN _allowed_dates, _kpi , BLANK())