Forum Discussion
multiply parameter value with a column
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.
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.
1 Reply
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.