Measures into Columns

[Alex_0201]

Hi everyone! I have two mesures Total Depth and Total Time. Since I can't plot them in one line chart ( Depth vs Time where Time is on the X-axis), I need to convert these measures into columns. How do I do it?

Total depth = ((

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

return

IF(

_stepno=1,

SELECTEDVALUE('DM_WELL_PLAN_OP'[md_from]),

LOOKUPVALUE('DM_WELL_PLAN_OP'[md_to],'DM_WELL_PLAN_OP'[step_no],_stepno-1)

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

Total time = (CALCULATE(SUM('DM_WELL_PLAN_OP'[target_duration]),FILTER(ALL('DM_WELL_PLAN_OP'),'DM_WELL_PLAN_OP'[step_no]<MAX('DM_WELL_PLAN_OP'[step_no])))+0)/24

[v-kelly-msft]

Hi @Alex_0201 ,

Once converted to columns,you will get fixed values,which wont be changed by your parameter.

Try below expressions:

Total depth = (( 
var _stepno = 'DM_WELL_PLAN_OP'[step_no]
return
IF(
_stepno=1,
'DM_WELL_PLAN_OP'[md_from],
LOOKUPVALUE('DM_WELL_PLAN_OP'[md_to],'DM_WELL_PLAN_OP'[step_no],_stepno-1)
))+CD_DATUM[datum_elevation]*(-1)*0.3048
 

Total time = (CALCULATE(SUM('DM_WELL_PLAN_OP'[target_duration]),FILTER('DM_WELL_PLAN_OP','DM_WELL_PLAN_OP'[step_no]<EARLIER('DM_WELL_PLAN_OP'[step_no])))+0)/24

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Alex_0201]

Hi @v-kelly-msft many thanks! I've used the expression for creating a new column called Total time, but its values are higher than in the measure by constant 0.04. Any idea where is this difference coming from?

[v-kelly-msft]

Hi @Alex_0201 ,

Could you pls provide  me some raw data in editable format to test?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Alex_0201]

Hi @v-kelly-msft would this table do?

[v-kelly-msft]

Hi @Alex_0201 ，

Not exactly,this format will be a time cost,if possible,could you pls upload your .pbix file to onedrive business and share the link with us?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mwegener]

Hi @Alex_0201 ,
I would say that is not possible.
Columns are static and measures are dynamic.
If the dynamic is to be preserved, this is not possible.

Otherwise you can create a corresponding calculated table if necessary.