Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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?
Solved! Go to Solution.
Right answer from @AIB
Measure = VAR Count_ = INT ( [Measure1] <> BLANK () ) + INT ( [Measure2] <> BLANK () ) + INT ( [Measure3] <> BLANK () ) RETURN DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )
Right answer from @AIB
Measure = VAR Count_ = INT ( [Measure1] <> BLANK () ) + INT ( [Measure2] <> BLANK () ) + INT ( [Measure3] <> BLANK () ) RETURN DIVIDE ( [Measure1] + [Measure2] + [Measure3], Count_ )
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |