Dynamic column in dashboard that would recalculate based on parameter value?

Hi, 改善 

Based on your description, I use the following sample data:

I'm going to use summarize to create a new table with the following parameters:

Table 2 =
SUMMARIZE ( 'Table', 'Table'[Required Input] )

I have established the following relationship between the original table and the new table:

I'm using the following DAX to determine if a field in another chart is selected, and if so, Scenario 2024 is calculated:

Scenario 2024 =
IF (
    ISBLANK ( SELECTEDVALUE ( 'Table 2'[Required Input] ) ),
    BLANK (),
    MAX ( 'Table'[Cost 2024] ) * ( 1 + [Parameter Value] )
)

In other charts, use the parameters of the new table:

Here are the results:

I've provided the PBIX file used this time below. You can adjust Scenario 2024 to suit your actual situation and add more conditions to meet your requirements.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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