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 , I belive there must be some math there, Though i have no idea how acheive this ?

what i want is , the Audience can play with the Parameter to see how their NSR and Volume UC impact if the %Mix chaged by up or down , Also the %Mix will be only equal to 100% , If these 2 more than 100% , we may need to block it. 
i belive the What if Parametor will have 2 parameter there Juice and Milk. 

Can anyone help me to acheive this ?  

Show and Tell

4 Replies

  • 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.

     

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

    v-yanjiang-msft , hey , you're so brilliant , you just meet my expextation right now. 
    Though , can i change my purpose a little bit , Now i would like the audience to play with the UC and NSR Parameter on Mix , Meaning they will adjust the Mix by each Name , Juice and Milk , 
    now we don't wanna block a 100% Anymore. 
    May i know how ? i think we are on the right track right now. 
    🙂 

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

      they will play with the mix , 
      i have around 10 Categories , so , i would like them to play with all the mix , And then if all mix exceed 100% , we will use the card visualization to aleart them . but the purpose is to give them play with the mix. 

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Chanleakna123 ,

        Could you show the expected result like in the original post?

        Best Regards,
        Community Support Team _ kalyj