Hi Guys,
First time posting here and a total powerbi newbie so be gentle 🙂 I'm fairly sure what I want to do is not possible but here goes.
I'll try to simplify what we are trying to achieve so its easier to understand. We are trying to create a fairly dynamic report using what if parameters, the values of which will affect various calculated measures in the model.. Lets say for explanation purposes we have a very simple budget table with year and total budget. We then have 3 business budget areas - salaries, fees and construction. We would like these 3 variables to be what if parameters so the user can determine the outcome of changing these on various model measures in other tables, they would be slicers with available values in the range between 0.01 and 0.7 - denoting 1% up to 70%. In this simple model lets say we create 3 measures in the budget table - salary budget, fees budget and contruction budget. The formula for the salary budget measure would therefore be total budget * selectedsalarybudgetparametervalue.
In this scenario none of the individual budget area what if parameters can have a value of more than 70% which is great. The problem is we do not want the user to be able to exceed 100% of total budget across the 3 areas. Because the parameters are not linked, you can set each of them to 70% which effecitvely allows the user to be able to set the total budget for all areas combined to be 210%. The paramters combined can equal less than 100%, but should never be over.
Lets say all parameters are initialized at 0. What I would like to achieve is if a user, for example, selects the full 70% on the salaries slider, the maximum value that can be selected in either of the other sliders is 30%. If the user then selected 10% for the fees slider, the max value for the remaining construction slider would be 20%. This should work across any order of selection
Any ideas if or how the above could be done? It doesn't have to be whatif parameters. If you need further clarification let me know.
Many thanks in advance.
