Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Proud to be a Super 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".
Proud to be a Super User!
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
Proud to be a Super User!
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".
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |