Calculating an average in a column with blank values

[RvdHeijden]

Goodday,

I want to calculate an average in a column which has blank values.

Basically i want the formula to only count the rows with values and ignores the ones that don't.

[v-huizhn-msft · Accepted solution]

Hi @RvdHeijden,

You can create a measure using the formula as follows, then you can create a card visual to display the result.

average =
DIVIDE (
    CALCULATE ( SUM ( Table[column] ), ALL ( Table ) ),
    CALCULATE ( COUNT ( Table[Column] ), Table[Column] <> BLANK () )
)

Please replace the 'Table' and 'column' name as your table name and column name.

Best Regards,
Angelia