Comparing two tables for Non Matched and Matched Rows to show in One Visual.

[tulasi_pbi1988]

Hi,

I have a scenario to show matching and non-matching rows in the Pivot table.

Currently showing in two pivots as used Measure to filter.

Sample data are shown in the below image.

Flag(measure) = if(NOT(CONTAINS(Tables1,Table1[PRID],SELECTEDVALUE(Table2[PRID]))),1)

Thank You.

[Anonymous]

HI @tulasi_pbi1988,

I'd like to suggest you add a calculated column to 'table 1' to show the tag based on 'table 2' records.

Column =
IF (
    COUNTROWS (
        FILTER (
            Table2,
            [Country] = EARLIER ( Table1[Country] )
                && [Prid] = EARLIER ( Table1[PRID] )
        )
    ) > 0,
    "Matched",
    "No Matched"
)

EARLIER vs EARLIEST in DAX - Excelerator BI

Regards,

Xiaoxin Sheng

[aj1973]

Hi @tulasi_pbi1988 

I see your thread, and going back to your questions:

If the relationship is Many to Many means? Make no difference but it is better to have 1 to many relationship

I have the same scenario to do, but I have Many to Many relationship. Where is the issue??

Do you have anything like this, please? Did you download my Pbix sample from the other Thread?

[VahidDM]

Hi @tulasi_pbi1988 

Please see this link:

https://radacad.com/combining-tables-in-power-bi-union-except-and-intersect-in-dax

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

Appreciate your Kudos!!