trying to convert calculated column to measure in dax

[Sri57]

I was trying to convert this dax column in to measure which I'm failing, Can anyone of you help me on this?
IF(ISBLANK([Ship Date]),BLANK(),
CALCULATE(MIN('Table A'[Ship Date]),
FILTER('Table A','Table A'[Customer]=EARLIER('Table A'[Customer])),
FILTER('Table A','Table A'[Status]="Shipped"),
FILTER('Table A','Table A'[Item]<>"TAP")))

[Jihwan_Kim · Accepted solution]

HI,

I am not sure how your semantic model looks like or how your expected outcome of the visualization looks like, but please try something like below whether it suits your requirement.

expected result measure: =
CALCULATE (
    MIN ( 'Table A'[Ship Date] ),
    FILTER (
        'Table A',
        'Table A'[Ship Date] <> BLANK ()
            && 'Table A'[Customer]
                IN VALUES ( 'Table A'[Customer] )
                    && 'Table A'[Status] = "Shipped"
                    && 'Table A'[Item] <> "TAP"
    )
)

[Anonymous · Accepted solution]

Hi @Sri57 ,

You can create a measure as below to get it, and the precondition is the field [Ship Date] and [Customer] need to be applied on the visual.

Measure  =
VAR _shipdate =
    SELECTEDVALUE ( 'Table A'[Ship Date] )
VAR _customer =
    SELECTEDVALUE ( 'Table A'[Customer] )
RETURN
    IF (
        ISBLANK ( _shipdate ),
        BLANK (),
        CALCULATE (
            MIN ( 'Table A'[Ship Date] ),
            FILTER (
                ALLSELECTED ( 'Table A' ),
                'Table A'[Customer] = _customer
                    && 'Table A'[Status] = "Shipped"
                    && 'Table A'[Item] <> "TAP"
            )
        )
    )

Best Regards

[talespin]

hi @Sri57 

Please share sample data and data model.

[Jihwan_Kim · Accepted solution]

HI,

I am not sure how your semantic model looks like or how your expected outcome of the visualization looks like, but please try something like below whether it suits your requirement.

expected result measure: =
CALCULATE (
    MIN ( 'Table A'[Ship Date] ),
    FILTER (
        'Table A',
        'Table A'[Ship Date] <> BLANK ()
            && 'Table A'[Customer]
                IN VALUES ( 'Table A'[Customer] )
                    && 'Table A'[Status] = "Shipped"
                    && 'Table A'[Item] <> "TAP"
    )
)