Forum Discussion
Change table values through parameter
- Anonymous4 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.
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.
- gianmarco4 years agoHelper IV
Thx, Sounds good enough 🙂