I have 2 tables,
Table A with column "ID" and other columns
Table B with one column "ID"
the ID values in both the tables keep updating.
I want to filter table A (filter out ID values in Table A, which are in Table B "ID" column).
Is there a way to establish this relationship?
Any help appreciated.
Solved! Go to Solution.
Do you want to filter in the Report or create a new table with Table A without the IDs equals in Table B.
Another Question.. The IDs in A & B are Duplicates or Uniques
thank you for the response.
I have tried this option, but I have many more constraints applied to Table A in the report which is creating a confusion.
Is there a way to create a column measure in Table A which will return 0 if the value is not present in Table B?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.