DAX Issue

Hello Rahp 

try this measure

Options Entered Lots (Open as of Date) =

VAR SelectedStrike = SELECTEDVALUE('Final MO MCX Options'[Strike])

VAR SelectedExpiry = SELECTEDVALUE('Final MO MCX Options'[Expiry Date])

VAR SelectedType = SELECTEDVALUE('Final MO MCX Options'[Type])

VAR SelectedLongShort = SELECTEDVALUE('Final MO MCX Options'[Long / Short])

VAR SelectedDate = MAX('DateTable'[Date]) -- will work even with ranges

RETURN

CALCULATE(

    SUM('Final MO MCX Options'[Lots]),

    FILTER(

        ALL('Final MO MCX Options'),

        'Final MO MCX Options'[Strike] = SelectedStrike &&

        'Final MO MCX Options'[Expiry Date] = SelectedExpiry &&

        'Final MO MCX Options'[Type] = SelectedType &&

        'Final MO MCX Options'[Long / Short] = SelectedLongShort &&

        'Final MO MCX Options'[Entry Date] <= SelectedDate &&

        (

            ISBLANK('Final MO MCX Options'[Exit Date]) ||

            'Final MO MCX Options'[Exit Date] > SelectedDate

        )

    )

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.