Forum Discussion
Solved
Proportionally allocation
Table name "Analysis" I want to allocate proportionally in one column the amount 50 at Business "B" sales and the anount 100 at Business "W". So it will be like row be row for business B: 100/(100...
Thank you all for your help.
After long searcing and advised by your solution I wrote the following which works based on me needs.
Column =
Business[Sales]/SWITCH(TRUE(),Business[Business]="B",CALCULATE(SUM(Business[Sales]),FILTER(Business,Business]="B")),Business[Business]="W",CALCULATE(SUM(Business[Sales]),FILTER(Business,[Business]="W")))
Try this "Calculated Column"
Allocation =
DIVIDE (
Analysis[Sales],
SUMX (
FILTER ( ALL ( Analysis ), Analysis[Business] = EARLIER ( Analysis[Business] ) ),
Analysis[Sales]
),
0
)
* SWITCH ( Analysis[Business], "B", 50, "W", 100, 0 )
Thank you all for your help.
After long searcing and advised by your solution I wrote the following which works based on me needs.
Column =
Business[Sales]/SWITCH(TRUE(),Business[Business]="B",CALCULATE(SUM(Business[Sales]),FILTER(Business,Business]="B")),
Business[Business]="W",CALCULATE(SUM(Business[Sales]),FILTER(Business,[Business]="W")))