Problem Total Average Category

[Syndicate_Admin]

Hello dears,

I would like to receive your help with the following problem.

I need to take the average of the total of a category, I am using the AVERAGE function but the tool with this function takes me the average of each month and the average of the total and what I need is that I only get an average of the total of the sum of the months (that is, the total)

Thank you for the help you can give me

As you see this table my problem is that I require the average of 2,568 which is the total of the column # Employees, the average is (642) and with the average function I get the average of each month and the average of the accumulated also resulting in 45.86, is there any way that I only get the average of the accumulated and ne leave the original values of the month to month?

[v-xiaotang]

Hi @Syndicate_Admin @Anonymous 

You can create the measures below,

sum= sumx(table,[# Employees])

count= calculate(countrows(table),filter(all(table),[# Employees]>0))

average= divide([sum],[count])

Best Regards,

Community Support Team _Tang

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

[SpartaBI]

@Syndicate_Admin basically you should use this logic:
MEASURE = AVERAGEX('Table'[Year_Month Column In Table], [Original Avg Measure])
Hard to give more info as there was no example supplied, but maybe that measure was all you needed.

Showcase Report – Contoso By SpartaBI