Forum Discussion

ChrisPBI's avatar
ChrisPBI
Advocate III
10 years ago
Solved

Data Model Value Average

Hello,   my data model says that a product can have emissions in four life cycle stages.   Example for product XY with A to D as the life cycle stages as table values:   Product    Life Cycle S...
Need Help
  • KGrice's avatar
    KGrice
    10 years ago

    Hi ChrisPBI. If you use =AVERAGE(TableName[Value]), you'll get 12.5. To get the sum of the value column divided by the number of products, you could use this measure:

     

    Measure = SUM(TableName[Value]) / DISTINCTCOUNT(TableName[Product])

     

    For your sample, that should evaluate to 50 / 1 = 50.

KGrice's avatar
KGrice
Memorable Member
10 years ago

Hi ChrisPBI. If you use =AVERAGE(TableName[Value]), you'll get 12.5. To get the sum of the value column divided by the number of products, you could use this measure:

 

Measure = SUM(TableName[Value]) / DISTINCTCOUNT(TableName[Product])

 

For your sample, that should evaluate to 50 / 1 = 50.