I want a metric, based on a value, to be able to be replicated across all dims..
i.e.
metric 1 = sum(X)
metric 2 = Sum(Case when @Select(dim) = 'CHARGE' THEN Sum(X) else 0 End)
thsi gives me;
col1 col2 col3
a 6 0
b 5 12
c 4 0
d 7 0
How can I get col3 to show all 12's???