The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
For our company's sales reps, we pay a commission based on the number of new accounts and average balance of those new accounts at a client level, not an overall level. Below is what I put together for one of our reps:
For example, client# 164 placed 49 accounts with an average balance over $50k. This results in a $500 commission for the sales rep for this client. This is repeated for each of the clients assigned to the rep. The measure for the Commission (Sign) column is:
The issue I'm running into is that it applies the measure to the total as well instead of summing the individual clients. If you add up each individual client's commission, you would get $3,000, but the logic applies to the overall total of the two preceeding columns, giving the overall commission $3,750.
I'm looking for one of two options:
Thanks!
Solved! Go to Solution.
@wildvike
You can wriap the measure in a SUMX to get the total to do what you want.
SUMX(Values('Table'[Client #]), [Commission (Sign))])
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@wildvike
You can wriap the measure in a SUMX to get the total to do what you want.
SUMX(Values('Table'[Client #]), [Commission (Sign))])
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Thanks, that worked for me!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
92 | |
90 | |
72 | |
69 |
User | Count |
---|---|
232 | |
128 | |
117 | |
82 | |
82 |