Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Help with an average measure excluding value

Hi   I was wondering if someone could help me? I have a score created through a measure, shown by day. This works fine. I can show the measure in a table of days and this gives me a rating per day ...
Need Help
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    Try with following

     

    Day Average =
AVERAGEX ( FILTER ( VALUES ( DateKey[Date] ), [Score] > 20 ), [Score] )

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Try with following

 

Day Average =
AVERAGEX ( FILTER ( VALUES ( DateKey[Date] ), [Score] > 20 ), [Score] )

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

That works brilliantly, thanks very much!!