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

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

  • 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]))

      • locle90's avatar
        locle90
        Helper I
        5 years ago

        Dear Matt,

        Greate.It's can work now.

        Thanks so much for your support.

         

        Loc Le