Forum Discussion

thomazinh's avatar
thomazinh
Helper I
4 years ago
Solved

Multiple What If parameters for same table different rows

I want to use the What If parameter for multiple rows in a table and have different What If parameters for a specific Cost ID types. I'm trying to calculate the Hours/Bid Value or the selected Parame...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    I thought it was a calculated column, not a measure. Try wrapping the Table4[WbsCode] in SELECTEDVALUE

johnt75's avatar
johnt75
Super User
4 years ago

I thought it was a calculated column, not a measure. Try wrapping the Table4[WbsCode] in SELECTEDVALUE

thomazinh's avatar
thomazinh
Helper I
4 years ago

I'm able to get around the error, but it doesn't look like its calculating what I'm needing now. 

 

Keeping all parameters at 1,

 

vs changing the parameters to various numbers.

 

EDIT**** The individual Factored values changed, but the Total at the bottom of the table did not change. The proposed solution worked. Is there a reason the Total at the bottom didn't update?