Forum Discussion
Multiply Values by Multiple Slicer/Parameters
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
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.
2 Replies
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/38490Hi 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.
