DISTRIBUTE A VALUE ACROSS MULTIPLE VALUES

Question

GOOD EVENING, I HAVE A TABLE OF SKU OF WHICH I HAVE SALES. ON THESE SALES. I CALCULATED WITH THE DAX THE PERCENTAGE SHARE.TO THESE VALUES I HAVE TO ADD A NATIONAL VALUE ( DISTINCT PER SKU) TO DISTRIBUTE AND ADD TO THE CURRENT VALUES. I CAN'T. CAN ANYONE HELP ME?&nbsp;EXAMPLE :&nbsp;&nbsp;&nbsp;ROMA&nbsp;MILANOTORINOTOTAL&nbsp;ROMA&nbsp;MILANOTORINOTOTALSKU_196733172&nbsp;56%42%2%100%SKU_2372465126&nbsp;29%19%52%100%SKU_3976361221&nbsp;44%29%28%100%SKU_4864685217&nbsp;40%21%39%100%SKU_540777124&nbsp;32%6%62%100%SKU_6966927192&nbsp;50%36%14%100%SKU_799693171&nbsp;58%40%2%100%SKU_82811746&nbsp;61%24%15%100%SKU_975945129&nbsp;58%7%35%100%SKU_10729095257&nbsp;28%35%37%100%SKU_11784696220&nbsp;35%21%44%100%SKU_1235293599&nbsp;35%29%35%100%SKU_1355686147&nbsp;37%4%59%100%SKU_14971788202&nbsp;48%8%44%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NAZIONALE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_1150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_2200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_3118&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_4122&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_5104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_6125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_7119&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_8119&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_9119&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_10141&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_11139&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_12119&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_13109&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SKU_14143&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

lbendlin · Answer

Do you need to distribute the national numbers across the three cities according to their weight?&nbsp; Does it need to result in integer numbers or are fractions acceptable?

Forum Discussion

DISTRIBUTE A VALUE ACROSS MULTIPLE VALUES

1 Reply

Related content

PQ -Date Distribution

Distribution Chart

Normal Distribution

Distribution calculation

MULTIPLE CARD

	ROMA	MILANO	TORINO	TOTAL	ROMA	MILANO	TORINO	TOTAL
SKU_1	96	73	3	172	56%	42%	2%	100%
SKU_2	37	24	65	126	29%	19%	52%	100%
SKU_3	97	63	61	221	44%	29%	28%	100%
SKU_4	86	46	85	217	40%	21%	39%	100%
SKU_5	40	7	77	124	32%	6%	62%	100%
SKU_6	96	69	27	192	50%	36%	14%	100%
SKU_7	99	69	3	171	58%	40%	2%	100%
SKU_8	28	11	7	46	61%	24%	15%	100%
SKU_9	75	9	45	129	58%	7%	35%	100%
SKU_10	72	90	95	257	28%	35%	37%	100%
SKU_11	78	46	96	220	35%	21%	44%	100%
SKU_12	35	29	35	99	35%	29%	35%	100%
SKU_13	55	6	86	147	37%	4%	59%	100%
SKU_14	97	17	88	202	48%	8%	44%	100%

	NAZIONALE
SKU_1	150
SKU_2	200
SKU_3	118
SKU_4	122
SKU_5	104
SKU_6	125
SKU_7	119
SKU_8	119
SKU_9	119
SKU_10	141
SKU_11	139
SKU_12	119
SKU_13	109
SKU_14	143