How do I calculate sales comissions per sales rep per month?

[Anonymous]

My dataset looks something like this: 

Month	Sales Rep	Quantity Sold
January	Ramon	50
January	Ramon	70
February	Jennifer	30

If a sales rep sells more than 100 units per month (like Ramon in the above example), that sales rep gets $1,000 in comission. How do I calculate a measure/calculated column for this comission? 

[FrankAT · Accepted solution]

Hi @Anonymous ,

you can do it like this:

Sum of Quantity sold = SUM('Table'[Quantity Sold])

Comission = IF([Sum of Quantity sold] > 100 , 1000 , 0)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[aj1973]

Hi @Anonymous 

You can add a measure

Commission = 

Var _Q = SELECTEDVALUE('Table'[Quantity Sold])

return

IF(_Q >= 100 , "$ 1,000" , "N/A")