Forum Discussion

Iceberg12's avatar
Iceberg12
Frequent Visitor
2 years ago
Solved

Need help to check the missing data in 02 different Columns.

Hello everyone,  I need your help on the following query:  I have table A: Number 1 2 3 4 5 and table B  1 2 and C: 4 5 I would like to ha...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hello! I have entered the following for A:

    The following for B:

    The following for C:

    If you want to show whether a value from A is found in B OR in C, use below:

    found_in_b_or_c = IF(
        COUNTROWS(
            INTERSECT(
                VALUES('Table A'[Column1]),
                UNION(VALUES('Table B'[Column1]), VALUES('Table C'[Column1]))
            )
        ) > 0,
        TRUE,
        FALSE
    )
     
    If you want to show if a value from A is found in B AND C, use the below:
    found_in_b_and_c =
    IF(
        COUNTROWS(
            INTERSECT(
                VALUES('Table A'[Column1]),
                INTERSECT(VALUES('Table B'[Column1]), VALUES('Table C'[Column1]))
            )
        ) = COUNTROWS(VALUES('Table A'[Column1])),
        TRUE,
        FALSE
    )
     
    Here are the results:

     

Iceberg12's avatar
Iceberg12
Frequent Visitor
2 years ago

Thank you for your suggest solution, but does that also work if Column B doesn't have the same row as Column C?

audreygerred's avatar
audreygerred
Super User
2 years ago

You're welcome. Yes, one of the DAX I provided will let you know if the same value is in b or c and the other is only if it's b and c.