Forum Discussion
Solved
Summin a calculated weighted average in a Matrix Column subtotal
I have a simple calculated weighted average formua which works exactly as expected: Totals = SUMX('Table', Table[Forecast_Value]*Table[DaysInMth])/SUMX('Table', Table[DaysInMth]) The Matrix disp...
Hi cschuchert
You may refer to below measure.
Totals = SUMX ( 'TableA', TableA[Forecast_Value] * TableA[DaysInMth] ) / SUMX ( 'TableA', TableA[DaysInMth] )Subtotal = VAR a = SUMMARIZE ( TableA, TableA[Division], "b", [Totals] ) RETURN SUMX ( a, [b] )Regards,
Cherie
You are a genius!! I saw your post where it looked like I hadn't sent the data-I'm not sure what happened to my post with the excel data but it's there now.
I cannot thank you enough!! I'll have to research SUMMARIZE so I understand how to apply it to other visualizations.
Regards,
Carolyn
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi cschuchert
You may refer to below measure.
Totals =
SUMX ( 'TableA', TableA[Forecast_Value] * TableA[DaysInMth] )
/ SUMX ( 'TableA', TableA[DaysInMth] )Subtotal =
VAR a =
SUMMARIZE ( TableA, TableA[Division], "b", [Totals] )
RETURN
SUMX ( a, [b] )
Regards,
Cherie
You are a genius!! I saw your post where it looked like I hadn't sent the data-I'm not sure what happened to my post with the excel data but it's there now.
I cannot thank you enough!! I'll have to research SUMMARIZE so I understand how to apply it to other visualizations.
Regards,
Carolyn