Average of multiple cells

Question

Hi,I have the following table, with 24 columnes and 62 lines. How do I calculate the avarage of only the columns with numbers?Is there a short way to calculate all in once?

cahabadata · Answer

If you mean the individual average per column - the table visual offers this option.

If you mean the sum of all columns together - and then determining a single overall average; this would require a dax calculation.

michalholtz · Answer

Thanks. Can you suggest a DAx calculation?

cahabadata · Answer

here's a sample air code:measureColumn X avg = Divide( Sum( Column X),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNT(Table, [Column X])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;The count function only counts rows that have a number and should be ideal in your situation.&nbsp;Set it up for a single column.&nbsp; Sanity check the result by temporarily using a Card visual to be sure the operation is correct.&nbsp; Then you can string together this same formula to add multiple columns.&nbsp;&nbsp;

Forum Discussion

Average of multiple cells

3 Replies

Related content

Daily Average Over Multiple Years

Average and Moving Average

Cells Offset

Average for each small multiple

Weekly Average