DAX Measure Help - Sales totals registered against one account to be divided by others

[James__]

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:

@actual_sales = SUMX(VALUES('Targets'[Product Name]), [product_sales]) which works fine for all other products, but i need to enhance it to do what I need for the example above.

Can anyone help, please?

J

[v-yaningy-msft]

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