Average Measure across numerous Months in a visual

[DebbieE]

this visual could contain a year or two years etc

I want some DAX to find the average Fact per month. So if 3 months are displayed, the average over the 3 months

If more months are displayed, the average over all these months.

Any help would be appreciated. does this make sense?

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=Calculate([your measure],allselected(Calendar))

There should be a Calendar Table which should have a relationship with the Date column of the Data Table.  To your visual, drag Year and Month from the Calendar Table.

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=Calculate([your measure],allselected(Calendar))

There should be a Calendar Table which should have a relationship with the Date column of the Data Table.  To your visual, drag Year and Month from the Calendar Table.

Hope this helps.

[DebbieE]

I think it may work but Im getting a different number to what I should be doing. i have added a flag to the card to specify a certain number of months

I think its more my calculations than Power BI though

thank you

[Ashish_Mathur]

Whom are you replying to?  Hasn't my solution worked?  If not, then share the link from where i can download your PBI file.

[DebbieE]

Should it not contains something regarding average?

[Icey · Accepted solution]

Hi @DebbieE ,

Try this:

Avg = AVERAGEX ( ALLSELECTED ( Calendar ), [your measure] )

Best Regards,

Icey

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

[DebbieE]

This hasnt worked. i have 6 months and years in my selection

The numbers are 829 1045 55 1174 57 1058

This came out as 31.95 as the average, shouldnt it be 703 ?

Im not quite sure what the 31.95 is