Total value from parameter formula

[Calouro]

Hi, I want to use one of my parameters result in a new calculation, but instead, I am always getting the formula and not the value itself. Does anyone know how to select only the result and not the formula? Thanks

[v-lili6-msft]

hi  @Calouro 

Essentially, Parameter is just a formula that returns a value.

so you could nest it into measure expression not just add it in the end of formula

For example:

Measure = SUMX('Table',[Qty]+[Parameter Value])

Measure 2 = SUMX('Table',[Qty]) +[Parameter Value]

Result:

If not your case, please share a simple sample pbix file and your expected output.

Regards,

Lin

[Calouro]

Hi, lin,

thank you for your answer, it is valid and got the point. The parameter can be used or not depending on the purpose.

I believe I have not explained myself correctly the first time. When I said parameter I should have said measure.

So, I have a measure that has a DIVIDE formula inside and I want to use the result it gets in another formula and not the formula itself. Is this possible?

Example below:

Measure1 = DIVIDE(('table1'[companyx OPEX] - [measure2]) ; SUM('table1'[cost1])) <=> Measure1 = 50