Forum Discussion

icturion's avatar
icturion
Resolver II
4 years ago
Solved

filter table by rows values

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 ...
  • DataInsights's avatar
    4 years ago

    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's avatar
    DataInsights
    4 years ago

    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".