average measure

[locle90]

Dear All,

I have a problem with the average production revenue in the BI report. I have a need to average sales as below. Value and brand entry daily. Can you help me create a measure to calculate the price that value?

Brand	Revenue
10	500
20	300
30	800
40	1000

average=(500/total revenue)*10+(300/total revenue)*20+(800/total revenue)*10+(1000/total revenue)*40

Thanks

[MattAllington]

Averagex(tableName,tableName[Brand] * tableName[Revenue])

[locle90]

Dear Matt,

Thanks for your reply but maybe not right.

Please refer my picture bellow.I have model and KG and i want to see value like that.

[MattAllington]

Ok, yes. Mine is simple average, yours is the weighted average. I think the following will work

SUMX(tableName,tableName[Model] * tableName[KG]/sum([tableName[KG]))

[locle90]

Dear Matt,

Greate.It's can work now.

Thanks so much for your support.

Loc Le