How to use these functions SUMX, AVERAGE ?

[Sashi_tripathi]

Can anyone help how to use these functions SUMX, AVERAGE in Power Bi

[v-jiewu-msft · Accepted solution]

Hi @Sashi_tripathi ,

I create the sample table to introduce the SUMX and AVERAGE function.

1.Create the simple table.

2.Create the new measure to calculate SUMX.

M_SUMX = CALCULATE(SUMX('Table', 'Table'[Values]), FILTER('Table', 'Table'[Year] = YEAR(TODAY()) && 'Table'[Month] <= MONTH(TODAY())))

3.Create the new measure to calculate AVERAGE.

AVERAGE_ = AVERAGE('Table'[Values])

4.You can also view the following documents to learn about SUMX and AVERAGE function.

AVERAGE function (DAX) - DAX | Microsoft Learn

SUMX function (DAX) - DAX | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.