Distribution Sales Target Across Locations

[Anonymous]

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                           Target

1                                       20

2                                       20

3                                       20

4                                       20

5                                       20

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.

[v-veshwara-msft]

Hi @Anonymous ,

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. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[Anonymous]

Hi @Anonymous ,

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 

Regards,

Xiaoxin Sheng

[Anonymous]

HI @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

[Deku]

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