Applying a percent increase based on a Parameter Selection

[alexjaco]

Hi,

I would like to apply a percent increase to only the value that is selected by the user in the [select task parameter] and return all other values as they are. Here is the current formula that I have

Adjusting 1 Cycle Time (hrs) = SWITCH(TRUE(), [Selected Task] = VALUES(Sheet1[Task]), CALCULATE(SUM(Sheet1[Cycle Time (Hrs)*])*1+'Percent Increase to Cycle Time'[Percent Increase to Cycle Time Value],FILTER(Sheet1,[Selected Task])), SUMX(Sheet1,Sheet1[Cycle Time (Hrs)*]))

[v-jayw-msft · Accepted solution]

Hi @alexjaco ,

After creating the independed slicer table, you could refer below formula.

Adjusting 1 Cycle Time (hrs) = IF(selectedvalue(sheet1[task]) in values('slicertable'[task]),[hrs]*(1+[percent increase]),[hrs])

Best Regards,

Jay

[amitchandak]

@alexjaco , this kind of formula can work well if the selected value is coming from an independent slicer. Say I select value A and I still want to display B,C,D etc along with A , then you need to use an independent slicer means create a table that is not joining with this table and use that as slicer 

Task = Sheet1[Task]

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI