Using the parameter value in a measure

[misharaina]

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]))

[misharaina]

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]

hat do you want to check on sgment ?

[misharaina]

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]

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

[Anonymous · Accepted solution]

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]

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