Forum Discussion
Commission Report
Hi, I am trying to build a commission report and I am trying to figure out, how to approach this with DAX. Could somebody help please? Here is my sample file: https://drive.google.com/file/d/1dwe8Fdu...
Here's how I would restructure the data model
I would also include a Products table and make sure the Product key is consistent.
This will make it much easier to compute the commissions. Do you want to calculate them by sales role, by sales rep , or in some other way?