Filtering Matrix Visual

[Anonymous]

Hi all,

I want to put some more complex filters on the matrix visual.

Basically I want to only show

1) Avg Pos > 0. All those " - " in this column, I don't want them to show in the visual but I don't know how to do this.

OR 

2) Pos % Change > 0.1 or < -0.1.  -> This is already achieved by setting the filter in the picture.

Here are the DAX calculation for all those columns in the matrix:

Avg Pos = 
IF(
    ISBLANK(
        AVERAGE('GSC query analysis'[Position])
    ),
    "-",
    AVERAGE('GSC query analysis'[Position])
)

Prev Month Avg Pos =
CALCULATE(
    [Avg Pos],
    DATEADD(
        'Calendar Lookup'[Start of Month],
        -1,
        MONTH
    )
)

Pos % Change = 
IFERROR(
    ([Avg Pos] - [Prev Month Avg Pos]) / [Prev Month Avg Pos],
    "-"
)

You help is much appreciated!!

[Anonymous · Accepted solution]

I have got it work myself by changing the DAX Calculation:

Avg Pos (Outliers) = 
        AVERAGE('GSC query analysis'[Position])

Prev Month Avg Pos (Outliers) = 
CALCULATE(
    [Avg Pos (Outliers)],
    DATEADD(
        'Calendar Lookup'[Start of Month],
        -1,
        MONTH
    )
)

Pos % Change = 
IFERROR(
    ([Avg Pos] - [Prev Month Avg Pos]) / [Prev Month Avg Pos],
    "-"
)

 And set the filter