How to load a DAX Expression into a Measure/yAxis?

[Dave82]

So high level, I'm looking to bring in my x/y axis calculations for a report from a metadata table in my database.  I have the following DAX expression I put in a Measure that works when I reference MOPR in the y-axis column value:

MOPR = Sum(mview_PARTS[PM_GOOD_TNE_PROD])/Sum(mview_PARTS[TRGT_PM_Prod])*100

So I created a parameter called yAxisExpression and loaded the above calc into it in the Power Query Editor and I want to bring the parameter's value into my y-axis.  So I tried a measure like this:

mtest_Measure = 'yAxisExpression'[yAxisExpression]

I get the following error:

A single value for column 'yAxisExpression' in table 'yAxisExpression' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

I can't seem to find much info on how to reference a parameter like this.

[AlexisOlson]

I'm not sure I understand why you're creating a new parameter. Doesn't [MOPR] work as your y-value?

[Dave82]

I want to switch the yaxis value dynamically while storing the calculations in a database table

[AlexisOlson]

Sorry. I don't follow what you mean.

Can you give an example of what you're trying to switch between?

[Dave82]

I just need to know how to get a parameter value and load the text into a measure?  Is that possible?

[v-shex-msft · Accepted solution]

Hi @Dave82,

So you mean you want to create a query parameter in the query editor and you want to extract that parameter value in DAX expressions?

If that is the case, I'd like to suggest you turn on the 'enable load' option of the parameter to enable power bi to transform and generated the data model table then you can use Dax aggregation functions to extract parameter table values. (e.g. min, max )

BTW, current power bi does not support working with measure expressions at the axis or legends fields. So if you want to use the custom field as the chart axis, please create a calculated table instead. After these steps, you need to write a measure on the value field to interact with the axis/legend and calculate results based on the current axis.

Regards,

Xiaoxin Sheng

[AlexisOlson]

I'm still not sure what you're asking, so I don't know if it's possible.