Forum Discussion

cschuchert's avatar
cschuchert
Frequent Visitor
7 years ago
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...
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

  • cschuchert's avatar
    cschuchert
    7 years ago

    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

cschuchert's avatar
cschuchert
Frequent Visitor
7 years ago

Thank you-I did find that post yesterday and can get the first part of the Measure I'm stuck on the false portion though. Here is the data for this app:

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

  • cschuchert's avatar
    cschuchert
    Frequent Visitor
    7 years ago

    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