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 formula? Thanks

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community 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