Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How To Get Average Which Exclude Repeat Value?

I encountered one problem about average, as below:   table is listed by WeekNum, so repeated month No. will be shown, then when calcuate average by month, it will be error.   any solution to exclud...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    Try as measure

    avergageX(summarize(table,table[Data]),[Data])

    or
    avergageX(summarize(table,table[Month],table[Data]),[Data])

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

Try as measure

avergageX(summarize(table,table[Data]),[Data])

or
avergageX(summarize(table,table[Month],table[Data]),[Data])