topic Re: Total value from parameter formula in DAX Commands and Tips

Total value from parameter formula

Calouro — Tue, 28 Apr 2020 10:01:25 GMT

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

Re: Total value from parameter formula

v-lili6-msft — Thu, 07 May 2020 02:22:49 GMT

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

Re: Total value from parameter formula

Calouro — Thu, 07 May 2020 18:21:06 GMT

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