Convert measure into a column

[Anonymous]

Hi 🙂 Is it possible to convet this measure into a column? 

Total depth = ((

var _stepno = SELECTEDVALUE('DM_WELL_PLAN_OP'[step_no])

return

IF(

_stepno=0,

SELECTEDVALUE('DM_WELL_PLAN_OP'[md_to]),

LOOKUPVALUE('DM_WELL_PLAN_OP'[md_to],'DM_WELL_PLAN_OP'[step_no],_stepno+0)

))+SUM(CD_DATUM[datum_elevation]))*(-1)*0.3048

[Anonymous]

Hi @Anonymous ,

I could not know the result you want based on a single measure. Please upload some data samples and expected output.

Last but not least! Please do mask sensitive data before uploading.Thanks.

Best regards,

Eyelyn Qin

[amitchandak]

@Anonymous , As you are using a slicer value. It will not respond to the changes in the slicer. Only the first value will be taken while creating the column. I think not possible.

[Anonymous]

hi @amitchandak thank you for the comment! Possible to find a workaround? 

[amitchandak]

@Anonymous , leave it like measure use "values", or summarize to put a context. 

example

sumx(Values(Table[User]),distinctCOUNT(Table[category]))
sumx(summarize(Table,Table[User],"_1",distinctCOUNT(Table[category])),[_1])

example - https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

https://www.youtube.com/watch?v=My0bLn9voo4

[az38]

Hi @Anonymous 

try smth like

Total depth = 
var _stepno = 'DM_WELL_PLAN_OP'[step_no]
var _tmp = 
IF(
_stepno=0,
'DM_WELL_PLAN_OP'[md_to],
LOOKUPVALUE('DM_WELL_PLAN_OP'[md_to],'DM_WELL_PLAN_OP'[step_no],_stepno+0)
)

return

_tmp 
+
SUM(CD_DATUM[datum_elevation]))*(-1)*0.3048

[Anonymous]

Hi @az38 thanks! but get this error message:

A table of multiple values was supplied where a single value was expected.

[az38]

@Anonymous 

I think it's because one (or all) of mentioned fields in statement is a measure that should be rewrtitten also

[Anonymous]

@az38 checked, they all are regular columns.