Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper III
Helper III

AVERAGE calculation

Hello all, 

I would like to ask you for your help with the following situation:

I have the table where I calculate average of filtered productivity by measure "Average":



But when I use the same measure "Average" in gauge I receive totally different number. And I found that the reason is that in the table I am using measure as filter (PO STATUS = "CLOSED") and for the gauge it is not possible. With this filter I am filtering which PO is closed:


When I try to define this filter directly to the "Average" metrics with Calculate formula, I receive this kind of error:


Any idea how to get the proper number to the gauge?

Thanks in advance.



Super User
Super User

@Peter_2020 , can you share the measure with error.


Also if you have measure then you can only filter it filter clause in calculate, not directly without filter in calculate



@amitchandak yes sure. here it is:



Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.