What-if Parameter for Only Selected Values

Question

Hey,&nbsp;I'm trying to create visualizations for managing project resources and what-if scenarios. I have a table where I have the demand, a table where I have the project names, and a table where I have the resource names and their roles.&nbsp;&nbsp;I have succesfully created a parameter which allows me to adjust the demand for all projects/resources, but I would like to be able to choose only specific projects or resources and adjust their demand.&nbsp;&nbsp;So basically I have a matrix that would look like this:Project Name&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DemandProject 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100Project 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50Project 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp;I would like to be able to choose only project 1 and adjust the demand by 10 % so the table would end up looking like this:Project Name&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DemandProject 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 110Project 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50Project 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 150Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 310&nbsp;But instead when I adjust the demand it always adjusts all the values by 10 % so that the total ends up to 330.&nbsp;&nbsp;My current Adjusted Demand uses this query:Adjusted Demand =&nbsp;VAR&nbsp; &nbsp; &nbsp;AdjustedDemand = INTERSECT( VALUES( ProjectData[Project Name]), ALL(ProjectData[Project Name]))RETURNCALCULATE(&nbsp; &nbsp; &nbsp;SUMX(ResourceDemandData, (ResourceDemandData[Demand] * (1 + [What-if Demand Value]))),&nbsp;&nbsp; &nbsp; &nbsp;AdjustedDemand)&nbsp;Is there something wrong with the query and how should it be changed to only apply to the selected projects?&nbsp;

v-juanli-msft · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
1.
Create a new table which has no relationship with other tables
slicer_project = SELECTCOLUMNS(VALUES(project[project]),"slicer_project",[project])
Add&nbsp;"slicer_project" in the slicer.
&nbsp;
2.
Create what-if parameter
this is a measure from "parameter" table
Parameter Value = SELECTEDVALUE('Parameter'[Parameter])
&nbsp;
3.
create measures in "project" table
Measure =
IF (
    SELECTEDVALUE ( slicer_project[slicer_project] ) = MAX ( project[project] ),
    MAX ( demand[demand] ) * ( 1 + [Parameter Value] ),
    MAX ( demand[demand] )
)

Measure 2 = IF(HASONEVALUE(project[project]),[Measure],SUMX(ALL(project),[Measure]))

Best RegardsMaggie
&nbsp;
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

What-if Parameter for Only Selected Values

2 Replies

Related content

What if parameter

What-If Parameter

What-If Parameter with Dynamic Range

What-if Parameter

Parameter selection for charts