Forum Discussion

Tevon713's avatar
Tevon713
Icon for Helper V rankHelper V
4 years ago
Solved

Measure total column per year incorrect

Hi all. I need help again. I was testing some measures and found out the the total of measure column is incorrect. With filters on the time period, the per month or row calculation look okay but whe...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    Hi Tevon713 ,

    Try these formulas as a measure

    Average of Monthly Divisions = 
AVERAGEX( 
    SUMMARIZE ( 'Table', Table[Year], Table[Month Name], "Div", [Divide Measure] ),
    [Div]
)
    Sum of Monthly Divisions = 
SUMX ( 
    SUMMARIZE ( 'Table', Table[Year], Table[Month Name], "Div", [Divide Measure] ),
    [Div]
)
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Tevon713 ,

For Sum Trx/Op Day, the formula is dividing the total Sum Trx by Op Day. What value do you expect? Sum of the monthly divisions? Average of the monthly divisions?

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Tevon713 ,

Try these formulas as a measure

Average of Monthly Divisions = 
AVERAGEX( 
    SUMMARIZE ( 'Table', Table[Year], Table[Month Name], "Div", [Divide Measure] ),
    [Div]
)
Sum of Monthly Divisions = 
SUMX ( 
    SUMMARIZE ( 'Table', Table[Year], Table[Month Name], "Div", [Divide Measure] ),
    [Div]
)
  • Tevon713's avatar
    Tevon713
    Icon for Helper V rankHelper V
    4 years ago

    Thank you very much danextian. The average of monthly divisions is what I'm after.