How to calculate a percentage if it is related to another value

[EAFN]

Hi everyone, I'm new to power BI and need some help with a problem. We receive different items quantities that come in different containers and I need to create a column/measure that tells me how much of the container is occupied by each item. This is an example of the data, we have the "ITEM", "QUANTITY" and "CONTAINER" columns, the "RESULT" column is the one that I need to create, thank you for your help.

ITEM	QUANTITY	CONTAINER	RESULT
A	9	AAA	0,600
B	4	AAA	0,267
C	2	AAA	0,133
D	6	AAB	1

[ryan_mayu · Accepted solution]

@EAFN 

pls try this

Column = DIVIDE('Table'[QUANTITY],CALCULATE(sum('Table'[QUANTITY]),ALLEXCEPT('Table','Table'[CONTAINER])))

if you want to create a measure ,pls try this

Measure = DIVIDE(sum('Table'[QUANTITY]),CALCULATE(sum('Table'[QUANTITY]),ALLEXCEPT('Table','Table'[CONTAINER])))

[EAFN]

Thank you, the measure worked for me.

[ryan_mayu]

you are welcome