Hi, I have simple calculation, that I thought would work with filtering, but I can't get it to work. My data:
I thought that my formula for result fieldwould work when slicing with groups but it doesn't.
Result = (Table1[Value] / sum(Table1[Value]) * Table1[X])
Correct results calculated with excel are -13.333 for group A and -35.5556 for group B. I assume that my sum functions doesn't work in filtering but how do I write this that weight part is only calculated for grouped part?