Need to apply different percentage value to different slicer selections dynamically

[Uthraa92]

Hi all,
I need help to create the below logic in PowerBI using DAX query.
I have these main fields - Department, Employee Number, Employee Name and amount field for Salary (as shown below - Table A).
Table A:

I have separate slicers for Department, Employee Number and Employee Name. I also have a parameter set to get the Hike % from the user. The main challenge is to get different hike % for different combinations applied in the filters (as shown below) and get everything in a table visual.

The final step is to calculate the revised salary based on the Hike % provided for each employee (as shown below) in another visual.

Wanted to check if this ask is doable in first place (i.e getting Hike % as dynamic input for different filters applied). Would really appreciate if there is some approach to get these Hike % as use input instead of hardcording it in the backend. Thanks a mil!

[mickey64]

For your reference.

Step 0: I use these data.

Step 1: I make a measure and make a matrix.

Revised Salary = SUMX('Table A','Table A'[Salary]*RELATED('Hike Table'[Hike %]))

[Uthraa92]

Thanks a mil! @mickey64 

Is there any way I can give the provision to the user to provide the Hike % on PBI itself instead of creating a list in the excel ? That is the main challenge at my end.

[mickey64]

I don't know what rules are used to determine "Hike %," but as an example I have provided a report and a table of "Hike %" based on evaluation results.
What rules do you want to use to determine "Hike %"?
If you want to calculate "Hike %" based on some rules, you can add a calculated column with an "IF" statement.

[Uthraa92]

There are no fixed rules for now. The user may consider one Hike % for each department or they can unselect few employees in that department and only for those and the remaining employees with another Hike % so it is completely dynamic for now.

Thanks!

[Anonymous · Accepted solution]

Hi, @Uthraa92 

You can try the following methods.

Revised Salary = CALCULATE(SUM('Table'[Salary]))*MAX('Hike%'[Hile%])

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

[Uthraa92]

Thanks @Anonymous 

Sorry for the late response.

Yes I needed that Revised Salary to be calculated based on different selections but as shown in your example, I need the first table and second table together. That is, the final table should have all the Employees from all dept with the applied Hike%.