Forum Discussion

gianmarco's avatar
gianmarco
Helper IV
4 years ago
Solved

Change table values through parameter

Dear All, I'm struggling with a simulating scenario issue. What I have is the following (sample here: https://drive.google.com/drive/folders/1MVy3gaikJeTU0HA9pvtZq503w4BW7b3T?usp=sharing 😞 ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi gianmarco ,

     

    According to my understanding,

    1. Firstly you select Project1 and What-if Parameter =0.2 , then simulating demand =120.

    2. When switch to Project2 , Parameter still=0.2, you want to remain Project1 =120 and also show Project2 =60,right?

     

    If the Parameter do not need change, I'd suggest you use multiple selections in slicer at one time and modify you [Measure]:

    Measure = IF(MAX(project[project]) in ALLSELECTED(slicer_project[slicer_project]),MAX(demand[demand])*(1+[Parameter Value]),MAX(demand[demand]))

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.