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]