Forum Discussion
abc_777
Solution Specialist
4 years agohi
hi, I attached an excel file where I need a sales representative to target each month need a measure Marketing Reprsentative Name Item name Month Target (in % percentage) A pen ...
abc_777
Solution Specialist
4 years agoI updated my query for better understanding.
abc_777
Solution Specialist
4 years agohow can i do this measure
if
jhon then (total sale * 0.1)
if
Dan then (total sale * 1.1)
if
Bill then (total sale * 0.5)
also i want to put marketing person (Jhon, Dan, Bill) in slicer selection