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

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'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