Line Level Parameters?

Hi Anonymous ,

Thanks for lbendlin  reply. There is an alternative you can try, only when the data is small
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create three parameter

Parameter 1= GENERATESERIES(1, 2, 0.1)

Parameter 2 = GENERATESERIES(1, 2, 0.1)

Parameter 3 = GENERATESERIES(1, 2, 0.1)

Create a measure

Parameter Value = 
IF(
    SELECTEDVALUE('Table'[Opportunity]) = "Opportunity A",
    SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 1'[Parameter]),
    IF(
        SELECTEDVALUE('Table'[Opportunity]) = "Opportunity B",
        SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 2'[Parameter]),
            IF(
            SELECTEDVALUE('Table'[Opportunity]) = "Opportunity C",
            SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 3'[Parameter])
        )
    )
)

Final output

Best regards,
Albert He

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