Hide matrix rows without affecting values

[Anonymous]

Hi,

Is there a way I can hide rows in a matrix without affecting the value? Or get my measures to ignore the visual filters?

Context: I only want to see suppliers which have failed but when I set 'failed' to 'is not blank' in a visual filter, it takes out the highlighted row, resulting in the 'failed' column, the 'PO Documents' column and the 'Posted Documents' column all having the same value. I want to keep the totals the same, but hide this blank row, can it be done? If this can only be done in a table, then that's fine, as long as it works.

The code I've used to get 'PO Documents' and 'Posted Documents' is correct as I have the correct values, but the table currently shows lots of blank rows as pictured above where there aren't any failure reasons ('Currency Issue', 'No Receipts', 'Supplier Mismatch'). My Code is as follows.

Failed = 
CALCULATE(
    COUNTA(IMSDocuments[DocumentId]), 
    FILTER(IMSDocuments, IMSDocuments[PostingStatusId] = "6"),
    FILTER(IMSDocuments, IMSDocuments[POProcess] = TRUE),
    FILTER(IMSDocuments, ISBLANK(IMSDocuments[FirstAutoMatchFailureCode]) = FALSE)
)

PO Documents = 
CALCULATE(
    COUNTA(IMSDocuments[DocumentId]),
    FILTER(IMSDocuments, IMSDocuments[PostingStatusId] = "6"),
    FILTER(IMSDocuments, IMSDocuments[POProcess] = TRUE)
)

Posted Documents = 
CALCULATE(
    COUNTA(IMSDocuments[DocumentId]),
    FILTER(IMSDocuments, IMSDocuments[PostingStatusId] = "6")
)

So each time there is one less filter on the column.

Any help is really appreciated!

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try ISINSCOPE.

Measure =
IF (
    ISINSCOPE ( Table1[Column1] ),
    SUM ( Table1[Column2] ),
    CALCULATE ( SUM ( Table1[Column2] ), ALL ( Table1[Column1] ) )
)