Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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)
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)
Hi @Anonymous
You can add a measure
Commission =
Var _Q = SELECTEDVALUE('Table'[Quantity Sold])
return
IF(_Q >= 100 , "$ 1,000" , "N/A")
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |