Multiply Values by Multiple Slicer/Parameters

[Adam_PowerBI]

Hello,

I have 10 Teams, each team have different cost and can earn some % of bonus (value is in different table, defined per team and can differ from 0% to 100% of that value).

I know how to multiply values with  New parameter and control it via slicer but  how can I apply multiple slicers to this scenario? So each Team will have separatly controled bonus value presented as total (cost+bonus) value in table.

Best Regards

[v-jingzhang · Accepted solution]

Hi @Adam_PowerBI 

You can use a separate parameter for each team. And create a measure like below to calculate the values. The key is to use SWITCH function. In below example, I only use three parameters. You can append more parameters into it.

Bonus = 
VAR _Team = SELECTEDVALUE(Cost[Team])
VAR _Rate = SWITCH(_Team,"A",ParameterA[ParameterA Value],"B",[ParameterB Value],"C",[ParameterC Value])
RETURN
_Rate * SUM(Cost[Cost])

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[parry2k]

@Adam_PowerBI Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490