Forum Discussion

alexjaco's avatar
alexjaco
Frequent Visitor
5 years ago
Solved

Applying a percent increase based on a Parameter Selection

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)*]))
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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