Forum Discussion
Using selected value of what if parameter in a Calculated column
I am trying to get a number input from the end user using the What if Paramater. I would then like to use that number in a calculated column and show the calculated column as a category on a colum...
Also getting the same issue. I want to have a calculated column with an number (a) times a variable (y) (between 100% & 150% in increments of 5%) which is created via parameter. The column will not recalculate. To make it a measure how could I use the raw table data without average(a)or sum(a)? my formaula has ifs such that
if(or(isblank("a), "a" = 0), 0, if( "a" > "b" * ("y" - the value from the parameter), 1, 0))
for "y" i have tried replacing it with selectedvalue(parameter[parameter]) both directly and by creating another column.
I guess the question is how do I get "a" into a measure? max("a") doen't work. is there another keyword?