topic Re: Column from Measure in Developer

Column from Measure

elria — Mon, 08 Jun 2020 17:40:35 GMT

Hi all,

I need to use the value of a measure as input for another calculation and I woulld like to convert it to a column.

When I assign New Column=[Measure] is not working. Any idea how i can assign the value of the measure to a one-row column(single value)?

Thanks,

Elria

Re: Column from Measure

lbendlin — Tue, 09 Jun 2020 01:08:36 GMT

measures are influenced by the filter context. Columns live in a row context. They are not compatible.

Explain what you are actually trying to achieve.

Re: Column from Measure

elria — Tue, 09 Jun 2020 08:50:52 GMT

Hi @lbendlin,

Thanks for your reply. I need to pass a what-if parameter (single numeric value) in a python script where this value is used as variable in a function. I tried to pass the measure[value] itself but then i get the error in my python visual that there is too much data and to apply any filter/slicer. This is not the case when i remove the measure from the dataset though. My data is not that much.

Please check below some pictures. "User Input" is a waht-if parameter, which i would like to pass in my script.

The porblem is that currently the Column comes from the same table is the What-iF value (Column=Measure[Value]) but I would like to create such a column in my dataset where columns A and B live in order to call it in python. The What-if table though doesnt have any relationship with my main table.

User Input = GENERATESERIES(0, 2, 0.1)

MOC Value = SELECTEDVALUE('MOC'[User Input], 1) (measure)

Column = MOC[MOC Value] (column)

Thanks,

Elria