Average not working as expected

[Anonymous]

I have an table called "Suporte", each rows represents one "quantity", so, I made a column like this "Quantidade = 1", given an ordinary graphic, the sum function works fine! But average doesn't 😞

Here is the screenshot:

Any help?

[v-huizhn-msft]

Hi @Anonymous,

Have you resoved your issue? You select the Average(highlighted in yellow background), it doesn't work? Could you please post more details for further analysis?



Best Regards,
Angelia

[Vvelarde · Accepted solution]

@Anonymous

Hello, The Average of a list of 1s is 1.

[KHorseman]

What result are you expecting instead of 1?

[Anonymous]

Sorry, my example wasn't so good. If my drilldown is focusing on year, whats the average by month, if is focusing on month, whats the average by weekday.

[Anonymous]

It will probably be somewhat tricky to get the dynamic behavior you are looking for (sometimes average per month, sometimes average per day).  Doable, but not trivial.

In general, I would think about your average as  DIVIDE([Total Quantity], [Total Periods])

If you were talking the average per month... [Total Periods] could be something like DISTINCTCOUNT(Calendar[MonthNum]).  For per day average, probably just COUNTROWS(Calendar).

Through some   IF (ISFILTERED(...) )  you can likely get what you want ...

[KHorseman]

@Anonymousthe time frame doesn't matter. As @Vvelarde said, if every value is 1, the average is 1.