Forum Discussion

Tevon713's avatar
Tevon713
Helper 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
Super 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
Helper V
4 years ago

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