Forum Discussion
Solved
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 ...
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.
v-jingzhang
Community Support
Community SupportHi 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.