Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm looking for help on something I thought would be fairly simple, but I'm stck.
We have a report which combines a SQL query 'Sales' and a spreadsheet. The SQL query contains sales data and the spreadhseet 'Targets' contains the target categories.
The product sales are registered against a customer, and that customer is then allocated to one of our sales team.
The problem i have is that we have a particular product where the customer is an in house account, linked to one sales exec, but I want to split the total sales for this product only between the 5 people in the sales team.
Current DAX is:
Hi, @James__
Based on your description, you can write a MEASURE to mark the 5 people in the sales team (those who are part of the to-be-assigned people mark 1 and the others mark 0) and then assign them based on the markers. Because there is no table structure and data, you can't write the DAX for now, you can share the pbix file without sensitive data, the data table, the desired effect to be achieved (you can simulate it in excel, and the logic to achieve that effect)
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
27 | |
23 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |