Measure to average fare excluding the duplicates

[Anonymous]

Hello,

I have a table like this below where some rows are duplicates (due to reason so I cannot delete them), I woud like a measure that permit to calculate the avereage Fare for each resource taking fare only once for project. 

AAA shuold be (100+250)/2 and not (100+250+100)/3

Resource	Fare	Project
AAA	100	A111
BBB	200	A111
CCC	350	B222
DDD	135	C333
AAA	250	C333
BBB	350	B222
CCC	450	C333
DDD	450	B222
CCC	450	C333
DDD	450	B222
DDD	300	D444
AAA	100	A111

this is the table of correct averege result:

	Avarege
AAA	175
BBB	275
CCC	400
DDD	295

I don't know which is the best solution to solve this problem if measure or trough new table.

Could yu please help me?

Thank

GV

[amitchandak · Accepted solution]

@Anonymous , try measure like

averageX(summarize(Table,Table[Project],Table[Resource], Table[Fare]), [Fare])

or

averageX(summarize(Table,Table[Project],Table[Resource], "_1", max(Table[Fare])), [_1])