Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Calculate Average issue



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.




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

View solution in original post

Helper II
Helper II

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 ))

Not applicable

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.

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

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors