Distribution Sales Target Across Locations

Question

I have a sales target of 100 for the company.I have 5 locations.I want to distribute the 100 evenly across the 5 locations using Dax.Location&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Target1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;203&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;205&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp;I don't want to duplicate the code 5 times, I want 1 dax query that will take the 100 as input and the 5 locations, and output 20 for each location.

deku · Answer

Is this to add a column to a existing table, or create a new table. Will the 100 be from a existing table?

anonymous · Answer

HI&nbsp;Anonymous,
You can try to use following measure formula to calculate the average target based on current location amounts:
formula =
VAR inputted = 100
VAR locationCount =
    CALCULATE ( COUNTROWS ( VALUES ( Table1[Location] ) ), ALLSELECTED ( Table1 ) )
RETURN
    DIVIDE ( inputted, locationCount, -1 )
Regards,
Xiaoxin Sheng

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly&nbsp;
Regards,
Xiaoxin Sheng

v-veshwara-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries.&nbsp;
Otherwise, feel free to reach out for further assistance.
Thank you.

Forum Discussion

Distribution Sales Target Across Locations

4 Replies

Related content

PQ -Date Distribution

Tool tip Location

Distribution Chart

Normal Distribution

Distribution calculation