Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost Prodigy
4 years ago

What if Parameter - Playing with %Mix Column

Hi all ,  I'm trying to create "what if Parameter" with %Mix change , Meaning if i change the %Mix in the Parameter as shown in the column , the data will tell me how the UC and NSR will be impacted...
Show and Tell
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Chanleakna123 ,

According to your description, here's my solution.

1. Create two parameters.

2.Create four measures.

UC % Mix =
IF (
    ISINSCOPE ( 'Table'[Name] ),
    SWITCH (
        MAX ( 'Table'[Name] ),
        "Juice", 'UC Parameter'[UC Parameter Value],
        "Milk", 1 - 'UC Parameter'[UC Parameter Value],
        1
    ),
    1
)

UC = 5.45*'Table'[UC % Mix]
NSR % Mix =
IF (
    ISINSCOPE ( 'Table'[Name] ),
    SWITCH (
        MAX ( 'Table'[Name] ),
        "Juice", 'NSR Parameter'[NSR Parameter Value],
        "Milk", 1 - 'NSR Parameter'[NSR Parameter Value],
        1
    ),
    1
)

NSR = 30.6*'Table'[NSR % Mix]

Select the desired value in parameter, get the correct result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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