Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have a customer that is serviced by two sales reps. for reporting i need to split the total sales $'s between both reps.
this first visual shows "Lawrence" with the total sales
this next visual shows the correct way the report should divided the sales
simply stated
Customer sales = $100.
sale rep 1 sales from customer = $50.00
sale rep 2 sales from customer = $50.00
total sales = $100.00
Solved! Go to Solution.
Hi @FCF ,
Like this? Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @FCF ,
Like this? Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
More information is needed about your data and tables to provide a DAX expression that will get the sum of that customer for all reps that support them and divide by the # of reps. Please provide example data for your tables that contain both the sales and the rep/customer assignments.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |