dynamic parameter

Hi Giada90 ,

Ritaf1983 , thanks for your concern about this case.

I made an attempt based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution:

1. Using the  original data:

2. Create four measures which meet your requirements:

actual = SUM('Table'[actual])

Actual+Prevision1 = SUM('Table'[actual]) + SUM('Table'[prevision 1])

Actual+Prevision2 = SUM('Table'[actual]) + SUM('Table'[prevision 2])

Actual+Prevision3 = SUM('Table'[actual]) + SUM('Table'[prevision 3])

3. Create field parameters:

4. Using parameters as values for the matrix.

5.The result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!