Forum Discussion

Yollies's avatar
Yollies
Helper I
6 years ago
Solved

Q and A function for Average

I have a column that works out the yirld. I then use Q & A function to get the average for the column

However the average is coming down because of the ZZERO's. How do i ignore zero's?

thanks in afdvance

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Yollies ,

     

    You could create a new measure to calculate your average value.

     

    AVG =
CALCULATE (
    AVERAGE ( 'Table'[YourColumn] ),
    'Table'[YourColumn] <> 0
        && 'Table'[YourColumn] <> BLANK ()
)

     

    Then you could use a card visual to show it.

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Yollies ,

     

    You could create a new measure to calculate your average value.

     

    AVG =
CALCULATE (
    AVERAGE ( 'Table'[YourColumn] ),
    'Table'[YourColumn] <> 0
        && 'Table'[YourColumn] <> BLANK ()
)

     

    Then you could use a card visual to show it.