DAX measure for Average

[pfarahani]

Hello, 

I am trying to get a average for 1 row, multiple columns. Here is what I mean:

I have various Court's, and Total Filings for those courts over time, Jan 2020, Feb 2020 etc. I need to write a measure that gets the average total number of filings for each court across the entire time period that I have. Any help with this measure, thanks!

[Ashish_Mathur]

Hi,

Assuming you have dagged Year and Month to the column well of the matrix visual from the Calendar Table and the numbers are the result of a measure that you have written, say Measure 1, write this measure

Measure 2 = calculate([measure 1],all(calendar[YearMonth]))

I have assumed that YearMonth is a column in your Calendar Table.

Hope this helps.

[vojtechsima]

Hi, @pfarahani ,
I suggest doing what @PaulDBrown wrote.
But if you don'T wanna restructure your model, you can use something like his (but it's a bit awkward):

(AVERAGE('Table'[January2021])+average('Table'[February2022])+average('Table'[March2021])))/X //X=count of columns

[PaulDBrown]

If that is how your data is structured, you need to unpivot the Month-Year columns. 
you can the create a measure along the lines of:

Average Filings = CALCULATE (AVERAGE (Table[Filings]), ALLEXCEPT(Table, Table[Court]))