Forum Discussion

jfranco's avatar
jfranco
Frequent Visitor
2 years ago

Modify a calculated column from input in a visualization

Hello. Before I forget, thank you! Question for the knowledge base.   Is there a way to modify a calculated column from input in a visualization: This is a "rough" description of what I am tryin...
Need Help
jfranco's avatar
jfranco
Frequent Visitor
2 years ago

Edit:

Further to my question.

"Calculated columns are calculated at load and not affected by slicers and report interactions. You need a measure"

 

So I would need a measure such as:

 

Volume (new) at selected customer and selected location  = volume x selected %Change

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jfranco 

     

    Actually that there is a alternative workaround for your initial problem:

    First of all, create a measure to store the value of increase or descrease:

    For example, -50%:

    INC/DES = -0.5

    Then add a calculated column:

    Column = 'Table'[Volume]*(1+[INC/DES])

    The result is as follow:

    You can modify the measure to change the value of the DES or INC.

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jfranco's avatar
      jfranco
      Frequent Visitor
      2 years ago

      I appreciate your reply. That is what I previously had in my model.

      A  table that created the 'step change'
      [ Step_Change = GENERATESERIES(-.20, .20, 0.005) ]

      then a slider based on a measure

      Change Value = SELECTEDVALUE('Step_Change'[Step_Change])
      and finally the volume change :
      Volume Scenario = SUMX(Volumes, Volumes[Vol] * (1 + [Change Value]))
       
      but....that changes all the values for all customers, across all locations, on all dates
       
      I was looking more to change just "one customer" at "one location"
       
      See, I'm trying to stress test different manufacturing facilities....using the idea, of what doe total volume at x facility look like if customer y increases it's volume by z%
       
      Again, thanks