Issue with Joins

Hello @San1979 ,

I create a column in T1.

Column = LOOKUPVALUE(T2[Cat],T2[personUuid],T1[PersonUuid])

And then, create a visual table like this:

Therefore, the 313 records lost are "Cat - blank ()". But in T2, there is no "Cat - blank() option. The value "Total" is calculated on the basis of T1, not T2. You can create a measure as follows to correct the "Total" value:

Measure = 
    CALCULATE (
        COUNT ( T1[GroupId] ),
        FILTER ( T1, T1[PersonUuid] IN VALUES ( T2[personUuid] ) )
    )

Best regards

Icey

If this post helps,then please consider accepting it as the solution to help other members find it more quickly.

@Icey Thanks for the solution.

I just want to check, should the blanks be no match of personuuid b/w the 2 tables.

but I think what are the personuuids present in T1 should be there in T2, then why their target

cat is based on the condition

Hi Anonymous ,

But in T2, part of "personUuid" is not there. For example,

T1:

T2: no matched records.

Best Regards,

Icey