Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculation excluding blanks

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)

 

 

CarUnits
Mondeo8500
Fiesta0
Corsa 

 

Thanks!

Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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

1 Reply

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    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