Forum Discussion

BusinessAnalyst's avatar
BusinessAnalyst
Icon for Helper I rankHelper I
9 years ago
Solved

compare columns in two tables, differ the unique values

I'd like to compare two tables: Table1 contains all IDs   ID 1 2 3 4 5 6 7 8 9 10 11 12   Table 2: records only the IDs which purchase by month ID ...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    BusinessAnalyst

     

    In your scenario, to achieve your goal, we have to create a "dummy" column to filter the unselected IDs. Please refer to my sample below:

     

    1. Create a calculated column for tagging unselected IDs.

     

    Column = IF(ISFILTERED(IDs[ID]),0,1)

     

    2. Then filter IDs table where Column "is blank".

     

     

    3. Then just add a slicer in your report.

     

     

    Regards,

Naveenraddi's avatar
Naveenraddi
New Member
3 years ago

Hello - I see that you solved the below - can you please help with the below