Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rolling Average Measure Improper Calculation

I have a Rolling 7 day average metric that works well for the most part. However, for some reason, for some entities when I drill down to see the R7, the measure jumps off the page with a very high i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I have created a data sample to try to reproduce your case.

    You may try my method to calculate the sum volume of the rolling 7 days:

    Measure = 
CALCULATE(SUM(Volume[Volume]), FILTER('Volume',[Date]>=MAX('Date'[Date])-7 && [Date]<=MAX('Date'[Date])))

    See the differences:

    So Could you please provide me with more details about your table and your problem to help us clarify your scenario? Or share your pbix file after removing sensitive data 

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

I have created a data sample to try to reproduce your case.

You may try my method to calculate the sum volume of the rolling 7 days:

Measure = 
CALCULATE(SUM(Volume[Volume]), FILTER('Volume',[Date]>=MAX('Date'[Date])-7 && [Date]<=MAX('Date'[Date])))

See the differences:

So Could you please provide me with more details about your table and your problem to help us clarify your scenario? Or share your pbix file after removing sensitive data 

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.