Forum Discussion

locle90's avatar
locle90
Helper 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 the price that value?

 

BrandRevenue
10500
20300
30800
401000

 

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

 

Thanks

4 Replies

    • locle90's avatar
      locle90
      Helper 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
        Community 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]))