Forum Discussion
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 F.
thanks in advanced.
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 vResultUsing 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".
3 Replies
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 vResultHI DataInsights
If he use visual filter, why can't use the column "Overschrijding" directly in the visual filter with the condition F?
Thanks
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".
