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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Cre8
Regular Visitor

HELP: Calculate average from functions, dynamic divisor

I have a question and urgently ask for your help!!!
The following problem:

I have four data columns which I can filter (e.g. by month). In Power BI I have calculated the average per column using the AVERAGE function.

 

Mean V1=AVERAGE([Value1] -> New Measure: fx Mean V1
This for all 4 Values, meaning I get 4 functions (each the average of these individual columns).

 

So far so good.

 

Now I want to calculate the average over these four columns. Unfortunately, I cannot have AVERAGE calculated using functions (fx). Therefore I simply summed up the functions (fx) with CALCULATE and divided by 4

 

=CALCULATE([fx average V1]+[fx average V2]+[fx average V3]+[fx average V4])/4

 

This only works if all results of the functions (fx) contain values. If a function (fx) gives no values, the mean value is calculated incorrectly. What can I do now to get a dynamic divisor?
Is it somehow possible to generate again a mean value from functions?

1 ACCEPTED SOLUTION
Cre8
Regular Visitor

Right answer from @AIB

Measure =
VAR Count_ =
    INT ( [Measure1] <> BLANK () )
        + INT ( [Measure2] <> BLANK () )
        + INT ( [Measure3] <> BLANK () )
RETURN
    DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )

View solution in original post

2 REPLIES 2
Cre8
Regular Visitor

Right answer from @AIB

Measure =
VAR Count_ =
    INT ( [Measure1] <> BLANK () )
        + INT ( [Measure2] <> BLANK () )
        + INT ( [Measure3] <> BLANK () )
RETURN
    DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )
amitchandak
Super User
Super User

@Cre8 , try a new meausre like

 

Averagex({[fx average V1],[fx average V2],[fx average V3],[fx average V4]}, [Value])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.