Getting an average in a table's total

[Anonymous]

Hello, I created a dax formula to find out the previous month's data:

Detention tx detention M-1 = CALCULATE(SUM(Detention[TX_DETENTION_JOUR]), PREVIOUSMONTH('4 - Date'[Date]))

These data are percentages. But in the total row of my table, I have a percentage sum and not an average. Can you help me? THANKS.

[freginier · Accepted solution]

Hey! 

I think if you create a weighted average it should work, try using this formula instead: Detention_Tx_Avg = AVERAGEX( Detention, Detention[TX_DETENTION_JOUR] )

This formula will make sure it is not a sum of all averages. 

Hope this helps!

Zoe 😁😁

[Anonymous · Accepted solution]

It's OK! Thank you!!

[Anonymous]

Thank you!!!

[freginier · Accepted solution]

Hey! 

I think if you create a weighted average it should work, try using this formula instead: Detention_Tx_Avg = AVERAGEX( Detention, Detention[TX_DETENTION_JOUR] )

This formula will make sure it is not a sum of all averages. 

Hope this helps!

Zoe 😁😁