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

Hi,

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

  • Tevon713's avatar
    Tevon713
    Icon for Helper V rankHelper 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.