Forum Discussion

fireflyxxoo's avatar
fireflyxxoo
Frequent Visitor
3 years ago

Averagex Measure Excluding Blanks

Hello!

 

I am comparing two periods. For previous period I am using SAMEPERIODLASTYEAR. 

 

My measure is doing some basic calculations but it filters out values that dont exist in both columns.

 

I got the values that i needed in the column and now I have to average the new values.

 

When I am doing AverageX function for a column it returns to me a wrong number as if it is averaging more values that I am not aware. I used the following formula:

CALCULATE(AVERAGEX(VALUES(Table[Customer]),[Measure]),ALLSELECTED())

any suggestions?
 
Thanks!
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    fireflyxxoo , This seems fine and should not consider blank. but will consider 0

     

    AVERAGEX(VALUES(Table[Customer]),[Measure])

     

    And with date/calendar table

    CALCULATE(AVERAGEX(VALUES(Table[Customer]),[Measure]),SAMEPERIODLASTYEAR('Calendar'[Date]))

    • fireflyxxoo's avatar
      fireflyxxoo
      Frequent Visitor
      3 years ago

      Thanl you so much but when I do 

      AVERAGEX(VALUES(Table[Customer]),[Measure]) it doesnt return an average for the entire column. It forces me to do ALLSELECTED() to get 1 number but when I utilize all selected it's smaller number than when I do mean by hand..:(