How to create a check of various conditions?

[Anonymous]

Hello

I want to check that Table1[Col1]=Table2[Col2] or some other condition and I want to display the output of this check to a Card visual showing TRUE or FALSE.

I suppose one way is to create a column to check this condition, return 0 or 1 for TRUE/FALSE and then if the total is >0, there the card should show FALSE.

Would that be the most efficient way?

Thanks! 

[SivaMani]

@Anonymous, Are the col1 and 2 aggregatable? if yes, you can create a measure to do this?

share sample data and expected results.

[Anonymous]

@SivaMani mmm what do you have in mind?

Col1	Col2
A	C
A	A
B	A
B	B
B	B

[SivaMani · Accepted solution]

@Anonymous, You can try this

Measure = IF(
    AND(HASONEVALUE('Table (3)'[Col1]),HASONEVALUE('Table (3)'[Col2])),
    IF(VALUES('Table (3)'[Col1]) = VALUES('Table (3)'[Col2]),
    TRUE(),
    FALSE()
    ),
    "NA"
)