date as input and use in calculate Dax measure

[Anonymous]

Hi All,

I have to get start date and end date of return date id as user input and use them inside the dax measure. But when i put this measure inside the table i have, it should not change the other values in the table. Only this measure values should be changed.
note: if i use slicer of return date id and use it, the other column values are changing , if i off the edit interaction , the measure is not working. Hope you guys help.

net returned = CALCULATE(

    SUM('UW fact'[net_premium]),
     'UW fact'[return_date_id] > DATE(2023,01,01),

    'UW fact'[return_date_id] < DATE(2023,06,01)

)

Thanks for your help,
Bala

[Anonymous · Accepted solution]

Hi @Anonymous,

I’d like to suggest you create an unconnected date table(does not have relationship to raw table) as source of slicer. It should not interact with raw table fields, and you can use Dax expression to extract the filter selections.

net returned =
VAR selectedMin =
    MIN ( newTable[Date] )
VAR selectedMax =
    MAX ( newTable[Date] )
RETURN
    CALCULATE (
        SUM ( 'UW fact'[net_premium] ),
        FILTER (
            ALLSELECTED ( 'UW fact' ),
            'UW fact'[return_date_id] > selectedMin
                && 'UW fact'[return_date_id] < selectedMax
        )
    )

Regards,

Xiaoxin Sheng