Forum Discussion

Calouro's avatar
Calouro
Frequent Visitor
6 years ago

Total value from parameter formula

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 f...
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
Calouro
Frequent Visitor
6 years ago

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