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 ,

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?

Tevon713's avatar
Tevon713
Helper V
4 years ago

The "Sum Trx by Op Day" look okay. Think the issue is at (Sum Trx/Op Day / FTEs), FTEs should take average. If user select entire year, FTEs should be 1 not 12.