Forum Discussion

misharaina's avatar
misharaina
Advocate I
4 years ago
Solved

Using the parameter value in a measure

Using the parameter value in the measure doesn't work. Is this the standard behaviour?   Vol/mix new = IF( SELECTEDVALUE('Parameter'[Parameter1]) = "Customer" && HASONEVALUE('CustomerTable'[Cust...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi,

     

    No just declare it as a variable before the calculation

    Vol/mix new =
    var valparameter=SELECTEDVALUE('Parameter'[Parameter1])
    var result =if(HASONEVALUE('CustomerTable'[Customer]),
           [Vol/Mix Impact],
             SumX( ADDCOLUMNS(SUMMARIZE('Segment (Control)','Segment (Control)'[Segment]), "Vol/Mix New2", Calculate([Vol/Mix       Impact])), [Vol/Mix New2])))
     
    return
    result
Anonymous's avatar
Anonymous
Not applicable
4 years ago

hat do you want to check on sgment ?

  • misharaina's avatar
    misharaina
    Advocate I
    4 years ago

    The parameter is composed of dimensions. The parameter column has the following values -

    Parameter1

    Products

    Customers

    Segments

     

    I want to check if the "segment" is selected or not. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Ok more complicatd. Can you send me a sample of your datas ?