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'[Customer]),
       [Vol/Mix Impact],
         SumX( ADDCOLUMNS(SUMMARIZE('Segment (Control)','Segment (Control)'[Segment]), "Vol/Mix New2", Calculate([Vol/Mix       Impact])), [Vol/Mix New2]))
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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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
    • misharaina's avatar
      misharaina
      Advocate I
      4 years ago

      Thank you Anonymous ! I also want to check if the parameter value = "Segment" but it doesn't seem to work.

       

      Vol/mix new =
      var valparameter=SELECTEDVALUE('Parameter'[Parameter1])
      var result =if(HASONEVALUE('Segment (Control)'[Segment]) ,
      [Vol/Mix Impact],
      SumX( ADDCOLUMNS(SUMMARIZE('Segment (Control)','Segment (Control)'[Segment]), "Vol/Mix New2", Calculate([Vol/Mix Impact])), [Vol/Mix New2]))
      Return (IF (valparameter = "Segment", result, 0))
  • misharaina's avatar
    misharaina
    Advocate I
    4 years ago

    I created a numeric column inside the parameter and it works now. Thanks for your help in letting me know that it was essential to create a separate variable for the selected parameter value. 

  • 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 ?