Forum Discussion

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi mussaenda,

 

Try measure as:

AVG=
AVERAGEX(
       FILTER(
                    ALL('Date Table'), 
                    'Date Table'[Date] <= MAX('Date Table'[Date])
                ),
      CALCULATE(
      [average],
      filter(
      table,
      measure=0
               )
           )

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

mussaenda's avatar
mussaenda
Community Champion
5 years ago

Hi v-xulin-mstf ,

 

Thanks for your help.

The [average] is also a measure?

 

Thanks.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    4 years ago

    Hi mussaenda,

     

    It is the column in the table that need to be averaged.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

    • mussaenda's avatar
      mussaenda
      Community Champion
      4 years ago

      it requires an aggregation for [average]