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]
)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

35.59 is correct - 9005/253.  What is the problem?  

Tevon713's avatar
Tevon713
Helper V
4 years ago

The issue is when the user select entire year and not per month, it will be incorrect. The "Sum Trx/Op Day" is correct, however for the column "(Sum Trx/OP Day)/FTEs"... FTEs should take average and divide. So for year 2021 should be 35.59/1 = 35.59 not 2.97.