Forum Discussion

Helper III

3 years ago

Volume Split by %

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 Glob...

Tips and Tricks

Super User

3 years ago

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

Helper III

3 years ago

DataVitalizer
Super User
3 years ago
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
  Helper III
  3 years ago
  The break up is quite clear. It is in other columns.
  The global volume comes from out come of measure.
  - DataVitalizer
    Super User
    3 years ago
    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

Related content