Forum Discussion

tulasi_pbi1988's avatar
tulasi_pbi1988
Icon for Helper I rankHelper I
4 years ago

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

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.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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