What if Parameter- entering data manually for each row in a table to estimate total cost

[Chachi]

Hello,

I need some help with the following scenario if it is possible to do it in power bi:

I have a Labor data table in Power BI containing columns: labor categories and their associated rates. I have already built a table visualization that lists all labor categories and their rates, along with a slicer for filtering.

Now, my objective is to perform a what-if cost analysis. I want to select multiple labor categories and be able to manually enter projected hours for each selected category group. By doing so, I want to calculate the projected cost for each labor category based on their rate and estimate the total labor cost for all selected categories. Can anyone guide me on how to achieve this in Power BI? Your help is highly appreciated!

Below is a example of the my table

[Anonymous]

Hi  @Chachi ,

As far as I know, you might want to create a Parameter for each Labor Catogory, and have a manual value for each Labor Catogory implemented via the Switch() function

Here are the steps you can follow：

1. Create three Parameters – Modeling – New  Parameter – Numeric range.

2. Create measure.

Measure =
    SWITCH(
        TRUE(),
    MAX('Table'[Labor Catogory])="Type A",SELECTEDVALUE('ParameterA'[ParameterA]),
    MAX('Table'[Labor Catogory])="Type B",SELECTEDVALUE('ParameterB'[ParameterB]),
    MAX('Table'[Labor Catogory])="Type C",SELECTEDVALUE('ParameterC'[ParameterC]))

3. Result:

Best Regards,

Liu Yang

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

[Chachi]

Hi Liu,

Thank you for your response. I think one of the challenges with this is I have over 100 Labor categories, which means I would have to create a separate parameter for each? is there any other alternative?