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".
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
- tmorais4 years agoHelper I
HI DataInsights
If he use visual filter, why can't use the column "Overschrijding" directly in the visual filter with the condition F?
Thanks
- DataInsights4 years agoSuper User
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".