Volume Split by %

[shantupm5]

Hi Team

I have below global volumes and the region wise Volume share which is in %.

Please can you help me with the formula for volume disturbution based on % split mentioned ?

Total Global  Volumes	AMR	EMEA	APAC
15000	45%	15%	40%

[shantupm5]

The split i am looking out is of volumes.

thanks in advance

Prashanth

[DataVitalizer]

Could you provide a sample of the result you are trying to achieve 

Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated

[shantupm5]

[DataVitalizer]

Hi @shantupm5 
Do you have APAC AMR and EMEA stored in the same column? to suggest the adequate formula.

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helping? A kudos 👍 would be appreciated

[shantupm5]

The break up is quite clear. It is in other columns. 

The global volume comes from out come of measure. 

[DataVitalizer]

If your table looks like this 

1. I suggest you create a new calculated table using this code

NewTable = UNION(
  SELECTCOLUMNS('OriginalTable', "Attribute", "AMR", "Value",'OriginalTable'[AMR]),
  SELECTCOLUMNS('OriginalTable', "Attribute", "APAC", "Value",'OriginalTable'[APAC]),
  SELECTCOLUMNS('OriginalTable', "Attribute", "EMEA", "Value",'OriginalTable'[EMEA]))

2. Within this table create a new measure

Values = SUM('NewTable'[Value])*SUM('OriginalTable'[Total Global  Volumes])

the resut will look like this

Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
Was this exchange helpful? A kudos 👍 would be appreciated

[DataVitalizer]

Hi @shantupm5 
Are you trying to calculate the volume or the regions based on their %

Did it work ? 👌 Mark it as a solution to help spreading knowledge. A kudos 👍 would be appreciated