filter table by rows values

[icturion]

Hi,

How can I best filter a table based on the following conditions?

The intention is to only show the values ​​in column "Batchnummer" if the values ​​in column "Overschrijding" all contain an F.

thanks in advanced.

[DataInsights · Accepted solution]

@icturion,

Use this measure as a visual filter (where value is 1):

Filter False = 
VAR vCount =
    CALCULATE (
        COUNTROWS ( Table1 ),
        ALLEXCEPT ( Table1, Table1[Batchnummer] ),
        Table1[Overschrijding] = "T"
    )
VAR vResult =
    IF ( ISBLANK ( vCount ), 1 )
RETURN
    vResult

[DataInsights · Accepted solution]

@icturion,

Use this measure as a visual filter (where value is 1):

Filter False = 
VAR vCount =
    CALCULATE (
        COUNTROWS ( Table1 ),
        ALLEXCEPT ( Table1, Table1[Batchnummer] ),
        Table1[Overschrijding] = "T"
    )
VAR vResult =
    IF ( ISBLANK ( vCount ), 1 )
RETURN
    vResult

[tmorais]

HI DataInsights

If he use visual filter, why can't use the column "Overschrijding" directly in the visual filter with the condition F?

Thanks 

[DataInsights · Accepted solution]

@tmorais,

Using a visual filter with the condition "F" would include Batchnummer values that have a combination of "F" and "T". The requirement is to show only Batchnummer values where all rows are "F". Example:

If there are two rows for a Batchnummer value, and one row has "F" and the other row has "T", a visual filter would include the Batchnummer value. This would be incorrect, since the requirement is to show only Batchnummer values where all rows are "F".