Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate Average issue

Hi,

 

I am trying to get the average of each product and showing a card, like(picture 2).

By using Average, it gives me a wrong answer because the there are many rows of records with value =0, 

when it average out, the wrong average numbers are much smaller.

The total is fine, so I expect my average of product C is about 1K.

 

Any help is much appreciated.

 

Need Help
  • wwhittenton's avatar
    wwhittenton
    8 years ago

    Hmm. Perhaps make it a Measure, rather than a calculated column?

3 Replies

  • wwhittenton's avatar
    wwhittenton
    Helper II
    8 years ago

    If it's as simple as averaging a single column of data, you should be able to do this:

     

    Avg Product= CALCULATE( AVERAGE(TableName[ProductCount]), FILTER(TableName, TableName[ProductCount] <> 0 ))

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for your suggestion.

      I tried and still give me the same answer. Not sure if it calculate all rows of the data set.

       

      I have filter to show only 2017 months and I want to get the average for the reported months.

      • wwhittenton's avatar
        wwhittenton
        Helper II
        8 years ago

        Hmm. Perhaps make it a Measure, rather than a calculated column?