Sum with filter

[usrplead]

Hello everyone

Can someone help me with this issue I have, I need a measure that give me te sum from each item, and not apply to the color, the result must be like the second table

I want to know the percentage that represent each color in each item

Thanks for your help!

[Vera_33 · Accepted solution]

@usrplead 

Like this?

Measure = DIVIDE(SUM(yourTable[Value]), CALCULATE(SUM(yourTable[Value]),ALL(yourTable[Color])))