Average of Combined Measure

[SHOOKANSON]

I think this will be an easy one for somebody! I have a table with two entries for every day. Each entry is a numeric value, one "label a", the other "label b" - see below.

Date	Label	Amount
2/15/22	label a	1200
2/15/22	label b	500
2/16/22	label a	1330
2/16/22	label b	450

I am currently getting the quarterly averages for each label, but need the combined average. Any way I create this measure, I am getting the combined average of all rows. 

I am getting: (1200+500+1330+400)/4

I want: ((1200+500)+(1330+400))/2

Easy way to accomplish this?

[jdbuchanan71 · Accepted solution]

@SHOOKANSON 

Try this.

Average = DIVIDE ( SUM ('Table'[Amount] ) , DISTINCTCOUNT ('Table'[Label] ) )