Forum Discussion

Chaz's avatar
Chaz
Frequent Visitor
8 years ago
Solved

What if parameter not updating values in table column

I have a column with 10 rows containing the digits 1 to 10 in ascending order. I then create a second column with the formula =IF(col1 > 5, "Greater", "Less") and this gives me the intended result. If I then change the value '5' in the formula to the reflect the value of a what if parameter, all the columns say "Greater" and do not change when I update the what if parameter. Would anyone know why this happens?

  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Chaz

    “I then create a second column with the formula =IF(col1 > 5, "Greater", "Less")”
    It seems you created a calculated column using the parameter, right?
    As tested, it can change when I update the what if parameter using parameter in a measure instead.
    Measure = IF(MAX([col1])>[Parameter Value],"Greater","Less")
     
    Best Regards
    Maggie

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Chaz

    “I then create a second column with the formula =IF(col1 > 5, "Greater", "Less")”
    It seems you created a calculated column using the parameter, right?
    As tested, it can change when I update the what if parameter using parameter in a measure instead.
    Measure = IF(MAX([col1])>[Parameter Value],"Greater","Less")
     
    Best Regards
    Maggie