Forum Discussion
Solved
Sum with filter
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!
Like this?
Measure = DIVIDE(SUM(yourTable[Value]), CALCULATE(SUM(yourTable[Value]),ALL(yourTable[Color])))
1 Reply
Like this?
Measure = DIVIDE(SUM(yourTable[Value]), CALCULATE(SUM(yourTable[Value]),ALL(yourTable[Color])))