Forum Discussion

dgwoodard's avatar
dgwoodard
Frequent Visitor
5 years ago
Solved

Filtered table help

Hi all,
I hope that I can gain some advice on how to proceed in calculating a simple moving average with a period value depenant upon the variable parameter from a slicer.

The measure I currently have is as follows but the return is blank. The intention is to plot the moving average over top of the original data points to smooth out the volility. The catch is that I am not working with dates but rather with an indexed data set of various measurements.

DIAM_SMA_100 =
var PeriodValue = SELECTEDVALUE('Period Sample'[Period Sample])
var SelectedValue = SELECTEDVALUE('Table'[Index])
 
Return
AVERAGEX(
FILTER('Table',
MAX('Table'[Index])=SelectedValue &&
MIN('Table'[Index])= SelectedValue - PeriodValue),
CALCULATE(SUM('Table'[Measured Value])
))
 
I am still new to DAX and I believe my filter function is filtering evrything out (?). I would appreciate any insight into resolving or of an alternate method.
Thank you!
  • AlB's avatar
    AlB
    5 years ago

    Hi dgwoodard 

    I'd need to see more of the model but try this:

    DIAM_SMA_100 V2 =
VAR PeriodValue =
    SELECTEDVALUE ( 'Period Sample'[Period Sample] )
VAR SelectedValue =
    SELECTEDVALUE ( 'Table'[Index] )
RETURN
    CALCULATE (
        AVERAGE ( 'Table'[Measured Value] ),
        'Table'[Index] <= SelectedValue,
        'Table'[Index] >= SelectedValue - PeriodValue
    )

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    Hi dgwoodard 

    I'd need to see more of the model but try this:

    DIAM_SMA_100 V2 =
VAR PeriodValue =
    SELECTEDVALUE ( 'Period Sample'[Period Sample] )
VAR SelectedValue =
    SELECTEDVALUE ( 'Table'[Index] )
RETURN
    CALCULATE (
        AVERAGE ( 'Table'[Measured Value] ),
        'Table'[Index] <= SelectedValue,
        'Table'[Index] >= SelectedValue - PeriodValue
    )

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.