DAX Average

[cottrera]

Hi 

I have a table containing the following columns

Property Ref, Build Age, Property Type and Repairs Spend.

Property Ref	Build Age	Property Type	Repairs Spend
39	1919-1944	One Bed House	£1,013
139	1945-1964	Three Bed House	£32
219	1965-1982	Two Bed Flat	£361
123	1919-1944	Three Bed House	£201
114	Pre 1919	Two Bed House	£1,638
19	1965-1982	One Bed House	£976
179	1965-1982	Three Bed House	£1,117
24	Post 2002	Four Bed House	£1,645
71	1919-1944	Two Bed House	£886
136	1919-1944	Two Bed House	£1,128
82	Post 2002	Two Bed Flat	£996
177	1983-2002	Two Bed House	£1,482
34	Post 2002	Three Bed House	£1,262
60	1945-1964	One Bed Flat	£123
216	Post 2002	One Bed Flat	£100
190	Post 2002	Two Bed House	£200
47	1983-2002	One Bed Flat	£154
127	1983-2002	One Bed Flat	£34
125	1983-2002	Three Bed House	£1,189
220	1983-2002	One Bed Flat	£1,090
210	1945-1964	One Bed Flat	£967
176	Post 2002	One Bed Flat	£128

I would ike to summarise in two table visuals the following

Average Repairs Spend by Property Age

Average Repairs Spend by Property Type

Base on the data sample provided I would expect these results

Avg repair spend by build age Build AgeTotal

1919-1944	£807
1945-1964	£374
1965-1982	£818
1983-2002	£790
Post 2002	£722
Pre 1919	£1,638

and

Avg repairs spend by property type Property TypeTotal

Four Bed House	£1,645
One Bed Flat	£371
One Bed House	£995
Three Bed House	£760
Two Bed Flat	£679
Two Bed House	£1,067

thank you

Richard

[DataInsights · Accepted solution]

@cottrera,

Try this measure:

Average Repairs Spend = AVERAGE ( Table1[Repairs Spend] )