topic Re: trying to convert calculated column to measure in dax in DAX Commands and Tips

trying to convert calculated column to measure in dax

Sri57 — Tue, 20 Feb 2024 01:28:41 GMT

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")))

Re: trying to convert calculated column to measure in dax

Jihwan_Kim — Tue, 20 Feb 2024 03:47:00 GMT

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" ) )

Re: trying to convert calculated column to measure in dax

talespin — Tue, 20 Feb 2024 04:16:14 GMT

hi Sri57

Please share sample data and data model.

Re: trying to convert calculated column to measure in dax

Anonymous — Wed, 21 Feb 2024 07:15:54 GMT

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