Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Distribution Sales Target Across Locations

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                ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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