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
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.