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:

cschuchert's avatar
cschuchert
Frequent Visitor
7 years ago
DaysInMthDivisionForecast_DateForecast_PeriodForecast_TypeForecast_ValueGasFA GasFA McfeFA NGLFA OilFAVolumeMcfeNGLOilProduct_Type
312 LH8/29/2018 0:0010/1/2018 0:00Production11069800114730001147301106980004 Mcfe
312 LH8/29/2018 0:0010/1/2018 0:00Production11061711061711464900011464900001 Mcf
312 LH8/29/2018 0:0010/1/2018 0:00Production1300001313001302 Oil(Bbl)
312 LH8/29/2018 0:0010/1/2018 0:00Production0000 0 00003 NGL(Bbl)
313 MC8/29/2018 0:0010/1/2018 0:00Production003810000381000001 Mcf
313 MC8/29/2018 0:0010/1/2018 0:00Production0000031531500002 Oil(Bbl)
313 MC8/29/2018 0:0010/1/2018 0:00Production0000571057100003 NGL(Bbl)
313 MC8/29/2018 0:0010/1/2018 0:00Production000912600912600004 Mcfe
313 NL8/29/2018 0:0010/1/2018 0:00Production26176300274524002745242617630004 Mcfe
313 NL8/29/2018 0:0010/1/2018 0:00Production19771719771720901000020901000001 Mcf
313 NL8/29/2018 0:0010/1/2018 0:00Production893200091240912408932003 NGL(Bbl)
313 NL8/29/2018 0:0010/1/2018 0:00Production174300001795179500174302 Oil(Bbl)
314 SP8/29/2018 0:0010/1/2018 0:00Production191961000190754700190754719196100004 Mcfe
314 SP8/29/2018 0:0010/1/2018 0:00Production130149313014931311507000131150700001 Mcf
314 SP8/29/2018 0:0010/1/2018 0:00Production9343800089740089740093438003 NGL(Bbl)
314 SP8/29/2018 0:0010/1/2018 0:00Production958100009600960000958102 Oil(Bbl)
302 LH8/29/2018 0:0011/1/2018 0:00Production10827200112682001126821082720004 Mcfe
302 LH8/29/2018 0:0011/1/2018 0:00Production10819410819411260400011260400001 Mcf
302 LH8/29/2018 0:0011/1/2018 0:00Production1300001313001302 Oil(Bbl)
302 LH8/29/2018 0:0011/1/2018 0:00Production0000 0 00003 NGL(Bbl)
303 MC8/29/2018 0:0011/1/2018 0:00Production003722000372200001 Mcf
303 MC8/29/2018 0:0011/1/2018 0:00Production0000030630600002 Oil(Bbl)
303 MC8/29/2018 0:0011/1/2018 0:00Production0000556055600003 NGL(Bbl)
303 MC8/29/2018 0:0011/1/2018 0:00Production000889300889300004 Mcfe
303 NL8/29/2018 0:0011/1/2018 0:00Production25201400254158002541582520140004 Mcfe
303 NL8/29/2018 0:0011/1/2018 0:00Production19023019023019318600019318600001 Mcf
303 NL8/29/2018 0:0011/1/2018 0:00Production859500084320843208595003 NGL(Bbl)
303 NL8/29/2018 0:0011/1/2018 0:00Production170300001730173000170302 Oil(Bbl)
304 SP8/29/2018 0:0011/1/2018 0:00Production193449400200456800200456819344940004 Mcfe
304 SP8/29/2018 0:0011/1/2018 0:00Production131486313148631392232000139223200001 Mcf
304 SP8/29/2018 0:0011/1/2018 0:00Production9398400092522092522093984003 NGL(Bbl)
304 SP8/29/2018 0:0011/1/2018 0:00Production928700009534953400928702 Oil(Bbl)
312 LH8/29/2018 0:0012/1/2018 0:00Production10582100110610001106101058210004 Mcfe
312 LH8/29/2018 0:0012/1/2018 0:00Production10574610574611053600011053600001 Mcf
312 LH8/29/2018 0:0012/1/2018 0:00Production1200001212001202 Oil(Bbl)
312 LH8/29/2018 0:0012/1/2018 0:00Production0000 0 00003 NGL(Bbl)
313 MC8/29/2018 0:0012/1/2018 0:00Production003634000363400001 Mcf
313 MC8/29/2018 0:0012/1/2018 0:00Production0000029629600002 Oil(Bbl)
313 MC8/29/2018 0:0012/1/2018 0:00Production0000542054200003 NGL(Bbl)
313 MC8/29/2018 0:0012/1/2018 0:00Production000865800865800004 Mcfe
313 NL8/29/2018 0:0012/1/2018 0:00Production24375700239295002392952437570004 Mcfe
313 NL8/29/2018 0:0012/1/2018 0:00Production18390218390218167100018167100001 Mcf
313 NL8/29/2018 0:0012/1/2018 0:00Production831000079300793008310003 NGL(Bbl)
313 NL8/29/2018 0:0012/1/2018 0:00Production166600001674167400166602 Oil(Bbl)
314 SP8/29/2018 0:0012/1/2018 0:00Production189895800197882700197882718989580004 Mcfe
314 SP8/29/2018 0:0012/1/2018 0:00Production129094112909411370625000137062500001 Mcf
314 SP8/29/2018 0:0012/1/2018 0:00Production9255300092162092162092553003 NGL(Bbl)
314 SP8/29/2018 0:0012/1/2018 0:00Production878300009205920500878302 Oil(Bbl)