what if parameter| one slicer to change each row in a column

[Anonymous]

Hello everyone, 

Is it possible to change each row of a column with only one slicer of a what if parameter and a list ? 
I would like to have something like the picture attached, to have new price for each product, with saving the new values of all rows.

Can someone help me out with this please, thank you.

[Anonymous]

Can someone help me with this please ? 

[v-piga-msft]

Hi @Anonymous ,

I have a little confused about your desired output.

Do you want to get the output below?

If it is, you could use the measure Parameter value which is created automatically when you create the what if parameter.

If you need any other help, please share your desired output so that we could help further on it.

Best  Regards,

Cherry

[Anonymous]

Hi @v-piga-msft ,
Thank you for your answer, but I would like to give different value for each row like the picture billow, not the same value for all of them.

 

Best regards

[Anonymous]

I've tried this measure in the pictures bellow, 

butt once I change the product, I loose the value of the other one 

Can someone please help me with saving all the values 

[Anonymous]

Hello everyone , 

how do  I change each product price based on the user input from the slicer 
I would like to reach to following, like in the picture billow 

Thank you in advanced.

[v-piga-msft]

Hi @Anonymous ,

Sorry for the delay.

To get your expected output, please follow the steps below.

1. Create a calculated table with VALUES function.

Table = VALUES(Table2[product])

2. Create the measure with the formula below.

Measure =
VAR a =
    SELECTEDVALUE ( 'Table'[product] )
RETURN
    IF (
        ISFILTERED ( 'Table'[product] ),
        IF ( MAX ( 'Table2'[product] ) = a, [para Value], MAX ( 'Table2'[price] ) )
    )

Then you could create the slicer with the Product column in the calculated table.

Here is the output.

More details, you could refer to my attachment.

Best  Regards,

Cherry

[Anonymous]

Hi @v-piga-msft , 
Thank you so much for your answer and your attachment, but what I would like to have is different.
I would like to be able to keep the values that I choose each time , 
for example, in your picture attached product_3 have 420 as a new value, so when I select  product_4, I would like that product_3 keep the 420 value and not get the default price.
I hope I explained well this time , 
Thank you again for all your help  
Best  Regards.

[Anonymous]

I found solution. Not is the best solution mas it is worked for me.

I created one whats if param for each row in my table (=~ 20 rows) and switch it in dax expression.

Medida =
VAR __SELECIONADO = SELECTEDVALUE(Mercadologico[descricao])

RETURN
SWITCH(
TRUE();
__SELECIONADO = "ACOUGUE";ddACOUGUE[DDDV Valor];
__SELECIONADO = "ALIMENTOS";DDALIMENTOS[DDALIMENTOS Valor];
0)

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

By my research, I'm afraid that we cannot achieve your desired output as measure will changed by the filter context.

Best  Regards,

Cherry