Change values through slicer and measure linked to parameter

[gianmarco]

Dear All,

I have an issue and I hope I don't bother asking you for help.

I have a table with names (column "name") and a measure linked to the values of each name [values].

I'd like to have the chance to select one name at a time (I created a slicer) and change the values to simulate a different scenario (I created another measure and a parameter).

This measure is as follows : 

IF(SELECTEDVALUE(name[table1]),[values]*(1+[Parameter Value]),[values])

which is to say: I select a name through the slicer, if YES then show me the value changed according to the parameter, OTHERWISE show me the original value.

But when I select a name through the slicer it gives me an error. It says that I cannot convert the name (Text Type) in a True/False Type.

Is there any way I can accomplish my task?
Thank you very much for your help.

 

 

[amitchandak · Accepted solution]

@gianmarco , Try a measure like given below with name in the visual

IF(Max(Table1[Name]) = SELECTEDVALUE(Table1[Name]),[values]*(1+[Parameter Value]),[values])

[gianmarco]

Done a little testing and it seems working properly!

Thank you for your help @amitchandak 

🙂