I wanted to get the Average of a Measure used as Values and Display in a Card

[justnoob08]

I have a measure called SumOfMonth and it is the Sum of 2 other Measures.

I have a Matrix Table that uses Months for Row and is filtered by a slicer. I wanted to get the Average of SumOfMonth and Display it on a Card,

My Initial thought is to use Average and put the Measure name but it doesn't accept it. I'm really new to DAX and I can't figure out how to achieve this.

Thank you

[Anonymous · Accepted solution]

@justnoob08 

If you create a measure:

[Avg of SumOfMonth] =
AVERAGEX(
    DISTINCT( T[Month] ),
    [SUMMonth]
)

 it'll do what you want. If, for instance, you put it on the matrix, for each individual month it'll display [SUMMonth] and the total row will show you the average across the months in the matrix. Put the measure on a card and you'll get the average as well.

[justnoob08]

Thank you so much @Anonymous it worked liked a charm!

[justnoob08]

@amitchandak 

Below is my Sample, apologies I can't share a PBIX, So I added the measure Escalweight and Challengeweight to get SUMmonth then I wanted to display 2.25 as the average on a card.

Hope this is clear.

[amitchandak]

@justnoob08 ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.