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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Peter_2020
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":

Peter_2020_3-1676493582078.png

 

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:

Peter_2020_1-1676493303799.png

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

Peter_2020_2-1676493405197.png

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

Thanks in advance.

P.

 

2 REPLIES 2
amitchandak
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:

Peter_2020_0-1676535137512.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.