Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
3 years ago
Solved

Filter tabel by same values in different rows

Can someone help me with a formula for a calculated column that makes it possible to show only records that have two items A and B within the same number?   Example data: NR Item 1 A 1 ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Here's a column expression that returns T/F for Numbers 1 and 3 rows.

     

     

    ABonly =
VAR items =
    CALCULATETABLE ( DISTINCT ( T1[Item] ), ALLEXCEPT ( T1, T1[NR] ) )
VAR AB = { "A", "B" }
RETURN
    COUNTROWS ( INTERSECT ( items, AB ) ) = 2
        && COUNTROWS ( items ) = 2

     

    Pat

ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

Here's a column expression that returns T/F for Numbers 1 and 3 rows.

 

 

ABonly =
VAR items =
    CALCULATETABLE ( DISTINCT ( T1[Item] ), ALLEXCEPT ( T1, T1[NR] ) )
VAR AB = { "A", "B" }
RETURN
    COUNTROWS ( INTERSECT ( items, AB ) ) = 2
        && COUNTROWS ( items ) = 2

 

Pat