Dynamic column based on a numeric slicer

[Anonymous]

I have  numeric Slicer where a number is entered by the dashboard user. This number represents a percentage.  There is an amount value in the dataset. I want to create a new column by  multiply each of the amount values by the value the user enters in the slicer. For example, if the user enters 20, each value in the new column will be amount*20/100. Is it possible to do this? 

Thanks for the help. 

[Anonymous]

Hello,

You can add a series of numbers as a table using GENERATESERIES. 

You can then put that column in a slicer and turn on the single select.

Multiplier = GENERATESERIES(1,1000,1)

 Then create a measure to multiply you value by the multiplier:

Product = SUM('Table'[Value]) * SUM('Multiplier'[Value])

Depending on how you want the product output, you can add both the Value and the product in a table. You'll need to set the value to not summarize otherwise it will aggregate your values. OR you could place the second value in a slicer as well if that's what you're after?

Hope that helps!

Kim 

[amitchandak · Accepted solution]

@Anonymous , try what if parameter

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Measure = calculate(sum(Table[value])*[whatifmeasure])/100

[parry2k]

@Anonymous yes with a measure

New Measure = 
DIVIDE (
SUM ( Table[Amount] * [What-if parameter value],
100 )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!