Months with same value dax

[felipesaw]

Hi, i need help to calculate a formula. Sum the months of same value in dax

i need this result:

=sum (MonthValue *MonthsApply) / total months

In this example, would be:

=((1000*2)+(2000*1)+(2500*2)) / 5

Month	Value
Jan	1000
Fev	1000
Mar	2000
Apr	2500
May	2500

[CNENFRNL]

[tamerj1]

Hi @felipesaw 

this is the same as ( 1000 + 1000 + 2000 + 2500 + 2500 ) / 5 which equals to

AVERAGEX ( 

VALUES ( 'Table'[Month] ),

[Value Measure] 

)

[FreemanZ · Accepted solution]

Hi  @felipesaw 

 Try like:

Measure = 

DIVIDE(

    SUM(TableName[Value]),

    COUNTROWS(TableName)

)