How to manual enter different rate influenced by the required filter and make impacts on other field

[Anonymous]

I want:

I want it like:

If Trader = A or B, it turns out to be outrights electronic and use the commision rate for outrights electronic.

elseif outright/swap = swap and Region =DM, it turns out to be Swap DM and use the commision rate for Swap DM.

elseif outright/swap = swap and Region =EM, it turns out to be Swap EM and use the commision rate for Swap EM.

elseif outright/swap = outright and Region =EM, it turns out to be outright EM and use the commision rate for outright EM.

elseif outright/swap = outright and Region =DM, it turns out to be outright DM and use the commision rate for outright DM.

    -> I want those rates can be manually entered in a input box and have impacts on the commision amount( = commision rate * volume(known)).

I got an example for a finished one:

 The following commison amount uses this rate is:

Fixed Income Commission - Chart =

VAR SUBASSET = SELECTEDVALUE(table[Sub Asset Class])

RETURN

SWITCH(

    SUBASSET,

    "Investment Grade", SUM(table[Commission]) * 'Investment Grade'[Investment Grade Value] / 5,

    "High Yield", SUM(table[Commission]) * 'High Yield'[High Yield Value] / 12.5,

    "Nominal", SUM(table[Commission]) * Nominal[Nominal Value] / 1,

    "Inflation Linked", SUM(table[Commission]) * 'Inflation Linked'[Inflation Linked Value] / 10,

    "Loan", SUM(table[Commission]) * Loan[Loan Value] / 12.5,

    SUM(table[Commission]))

How can I realize that?

[v-shex-msft]

Hi @Anonymous ,

Maybe you can try to create what if parameters and used them in your measure:

Create and use a What if parameter to visualize variables in Power BI Desktop

Regards,

Xiaoxin Sheng