Forum Discussion
Calculating with a what if parameter
Super UserHey,
you need to tables, one that contains the values from you parameter (I assume that this table is called "Parameter" and one that just the column "Column 1". I call this other table "Other Table".
Now create a measure in "Other Table" like so:
Measure =
SUMX(
'Other Table'
,'Other Table'[Column 1] * [Parameter Value]
)
The measure [Parameter Value] is automatically created when you create the What If Parameter.
Hopefully, this is what you are looking for,
Regards,
Tom
Hey Tom,
Thank you for your answer. I tried your solution but it is not completely what my data needs.
My "Column1' values have some specific characteristics for why this is not working. It is also categorized, for which the values in each categorie should not add up. This is how the data looks like:
Number
Buildings
Value risk
1
67
1,40E-006
1
69
0,00E+00
1
91
1,08E-004
1
94
8,09E-005
2
67
1,40E-006
2
69
0,00E+00
2
91
1,08E-004
2
94
8,09E-005
3
67
1,40E-006
3
69
0,00E+00
3
91
1,08E-004
3
94
8,09E-005
So the category is building, with buildings 67, 69, 91 and 94. For each building, there is a number from 1 until 10. It is this number that I'd like to multiply (so this is "Column 1"), by multiplying it by a WhatIfParameter.
I think by using the SUM function, the values for number 1 of all the buildings are getting summed up.
The reason I want to keep the 4 building seperated is for making a line chart afterwards.
What I am doing now is making a line chart with a line for each of the buildings, with the value risk plotted and the Number on the X-axes. This gives me 4 different lines on the line chart. Now I'd like the X-axes (so "Number") multiplied by the WhatIfParameter, keeping the Value Risk the same for each value line.
When I use the measure created by your solution presented, I only get 1 line on the line chart.