Add filter to matrix so only negative values are shown

[HEW]

I have a matrix where the value is a measure "Running stock":

Running stock:=
CALCULATE (
    SUM (MAT_STOCK[Frit anvendelig] )+ SUM('ME80FN'[Qty])- SUM('Orders'[Qty]);
    FILTER (
        ALLSELECTED ('Date'[Date]);
        YEAR ('Date'[Date]) = YEAR (MAX('Date'[Date]))
            && 'Date'[Date] <= MAX ('Date'[Date])
    ))

We have quite a few articles and it is very difficult to find the ones, where the running stock is negative (red values).

Is it possible to add a filter, so only the articles with negative values are shown?

Thanks a lot in advance.

Br.

Helen

[v-yuta-msft · Accepted solution]

@HEW ,

You should modify your measure like pattern below:

Running stock =
VAR Para =
    CALCULATE (
        SUM ( MAT_STOCK[Frit anvendelig] ) + SUM ( 'ME80FN'[Qty] )
            - SUM ( 'Orders'[Qty] );
        FILTER (
            ALLSELECTED ( 'Date'[Date] );
            YEAR ( 'Date'[Date] ) = YEAR ( MAX ( 'Date'[Date] ) )
                && 'Date'[Date] <= MAX ( 'Date'[Date] )
        )
    )
RETURN
    IF ( Para < 0; Para; BLANK () )

Community Support Team _ Jimmy Tao

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

[amitchandak]

Try to have a visual level filter on the measure

[HEW]

@amitchandak  , I have tried but I am not able to select at measure for the filter. 

This is how you mean, right?

[amitchandak]

@HEW 

Drag to visual level filter in Filter Pane

Appreciate your Kudos.

[HEW]

@amitchandak  I have tried this as well. When I set the filter to be less than 0, the matrix is empty.

Just for test, I have selected less than 1 and this works - however then all the articles with 0 value shows 🙂 If I add another criteria that the value should not be 0, the matrix has no values at all....