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

Change your switch statement to

SWITCH( TRUE(),
    CONTAINSSTRING( Table4[WbsCode], "AAA"), DIVIDE( Hours, AAABid, 0),
    CONTAINSSTRING( Table4[WbsCode], "BBB"), DIVIDE( Hours, BBBBid, 0),
    CONTAINSSTRING( Table4[WbsCode], "FFF"), DIVIDE( Hours, FFFBid, 0),
    Unfactored
)
  • thomazinh's avatar
    thomazinh
    Helper I
    4 years ago

     

     

    I'm returning an error "single value for column WbsCode in Table4 cannot be determined...column contains many values... without specifying... a min, max, count, or sum to get a single result." I don't want any of those, but I do need to search in the text string. I'm thinking I'll need to use a CONTAINSTRING or something to get around it? 

     

    For more context, here is the link to the PBI file. 

    • 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?