Forum Discussion

locle90's avatar
locle90
Icon for Helper I rankHelper I
5 years ago

average measure

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 t...
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

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's avatar
locle90
Icon for Helper I rankHelper I
5 years ago

Dear Matt,

Greate.It's can work now.

Thanks so much for your support.

 

Loc Le