Forum Discussion

drosencrans's avatar
drosencrans
Frequent Visitor
9 years ago
Solved

Help with KEEPFILTERS within Calculation(Average)

My current problem: I have a measure from a summarized table for Location, Date, WeekNumber, Month, and Day based on MaxTransactionsDay.   I then need to create a new measure for AvgWeek: AvgTWeek...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    I'm 97% sure you are making this more complicated than necessary.  In as much as that I have been writing DAX for closer to 4 years and have no idea what KEEPFILTERS() even does :-P

     

    Not to ask a crazy question, but what is wrong w/ :

    AvgMeasureWeek = CALCULATE(AVERAGE('Table'[MaxPerDay]),FILTER(ALL('Date'),'Date'[WeekNum]=MAX('Date'[WeekNum])))

     

    ?

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I'm 97% sure you are making this more complicated than necessary.  In as much as that I have been writing DAX for closer to 4 years and have no idea what KEEPFILTERS() even does :-P

 

Not to ask a crazy question, but what is wrong w/ :

AvgMeasureWeek = CALCULATE(AVERAGE('Table'[MaxPerDay]),FILTER(ALL('Date'),'Date'[WeekNum]=MAX('Date'[WeekNum])))

 

?

 

drosencrans's avatar
drosencrans
Frequent Visitor
9 years ago

Hey Scott-

 

You are right!  Replacing Table with Date fixed the complexity I was working around.

 

Thanks for the direction!  Helps a lot.

 

Doug