multiply parameter value with a column

[Anonymous]

I want to multiply a parameter value with a column in my table and display the multiplied value in another column (matrix visualization).

I have created a what-if parameter as I want the input to be user defined, but I'm not able to figure out the correct DAX formula. I've attached the pbix file below for reference.

https://drive.google.com/file/d/1EAjpBP6U3pH3geX_6RrsY_zOrfEIzGz1/view?usp=sharing 

For eg, If I fill parameter as 1.5, the expected output should be:

Category	Balance	Multiplied value
A	2214	3321
B	2455	3682.5
C	1026	1539

Please let me know if there's another way to achieve this.

[camargos88 · Accepted solution]

@Anonymous ,

You just need to create a measure to multiply the value and the parameter value, like:

_NewValue = SUM('Table'[Balance]) * Parameter[Parameter Value]

Check the attached file.