Hello,
I have data:
Group, Option, Value, Group Value
A, 0, 23, 61
A, 1, 64, 61
A, 2, 32, 61
B, 2, 322, 41
B, 2, 35, 41
B, 2, 13, 41
etc.
I am trying to sum the group values across groups. In this case it would be 61 + 41 + etc..
I thought I could do this by creating a measure that creates the median for each group and then sum the measure (as below) but this does not work. Any suggestions?
What I tried:
1) `Median` --> {fixed [Group]: median([Group Value])}
2) and then summing across that.
I thought using a LOD would be right because [Group] is not in my bar chart. My bar chart is 3 bars: [Group Value], [Group Value2], [Group Value3]
update: it works correctly when I use {fixed[Group]: max([Group Value])}, but not with median. using max will work for my purposes, but why doesn't it return the same thing as median([Group Value])}?