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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
JohnAsh
New Member

How to show Total in Table as Average instead of sum

I have created a Quick Measure (Weighted Average by Category) which contains percentage values:

JohnAsh_3-1680265794107.png

 

 

The percentage values themselves are correct, but the total (450.70%) is the Sum of the above percentages. I want the Total to be the Average of the avobe percentages. 
Normally I would change the summerization from Sum to Average, but I cant seem to do this because it's a measure (I presume). 

For context, this is the measure:

 

Totaal % weighted by Contractuur per HV = 
VAR __CATEGORY_VALUES = VALUES('Alle tijd 2022 v2'[HV])
RETURN

    DIVIDE(
		SUMX(
			KEEPFILTERS(__CATEGORY_VALUES),
			CALCULATE([Totaal %] * SUM('Contracturen'[Contractuur]))
		),
		SUMX(
			KEEPFILTERS(__CATEGORY_VALUES),
			CALCULATE(SUM('Contracturen'[Contractuur]))
		)
	) 

 

 

EDIT: When I select multiple months (i.e. January and February), it also takes the Sum of the percentages as opposed to the average. How can i change this?



1 REPLY 1
amitchandak
Super User
Super User

@JohnAsh , use insinscope

 

if(insinscope (Table[Visual Column]) , [Your Measure], averagex(Values(Table[Visual Column]) , [Your Measure]) )

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors