Calculation excluding blanks

[Anonymous]

Hello!

I have the table below, and I want to calculate the average excluding blanks, in this case 4250. Something like

CALCULATE (average (units), units IS NOT BLANK)

Car	Units
Mondeo	8500
Fiesta	0
Corsa

Thanks!

[selimovd · Accepted solution]

Hey @Anonymous ,

the following measure should to it:

Avg Units =
CALCULATE(
    AVERAGE( myTable[Units] ),
    myTable[Units] <> BLANK()
)

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.

Best regards
Denis

Blog: WhatTheFact.bi