Forum Discussion
filter table by rows values
- 4 years ago
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 - 4 years ago
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".
HI 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".