Forum Discussion
Matrix Subtotals
Hi all, I have a matrix as follows: I am trying to achieve both column and row totals of 100%. As you can see, this works correctly for the columns but for each row it sums the values ...
Hi gmsamborn,
I adjusted the code as follows and combined with the code given by Anonymous but no success:
% Summary Total = VAR SettlementVal = [Total] VAR SelectedName = MAX(Times[name]) VAR AllSettlement = CALCULATE ( [Total], FILTER(ALLSELECTED(Times), Times[name] = SelectedName) ) VAR Result = DIVIDE(SettlementVal, AllSettlement) RETURN Result
OK. I just thought I'd check.
I'll let Anonymous continue with this one.