How to associate the two tables with duplicate values?

[Yuvaraj]

Hi,

I have two tables with one common field it has duplicate values in both tables. For that i created one new unique table for the duplicate values inorder to associate with the two tables in Data Model. While designing the two table fields are not associated into one single table. Can you suggest how to solve this....

Regards,

Yuvaraj

[ovetteabejuela]

Not sure what your problem is, can please rephrase or post images or tables?

[Yuvaraj]

the above Image is my Datamodel, i told previously the two tables are have same field(IncidentID) with duplicate values so i create one unique table(IncidentID) for IcidentID but while report desigining it will not accept the values while drag two table fields into single report.

Regards,

Yuvaraj

[CahabaData]

As I understand your posts; 1Feb table and MHT table have multiple records with repeating Incident ID - so therefore you've created the Incident ID table with unique values; joining them together. This is the correct first step. 

Data modeling is not just tables but also may involve calculated columns or other specialty tables. 

What is unclear in your post is your goal.  Without knowing your goal one cannot be sure if the issue is your DAX syntax or whether further modeling is needed.

To write a measure involving fields from separate tables one must typically use the RELATED syntax in DAX.  A few rows of your sample raw tables and/or a few rows of your goal result can be very helpful to determine the best path from start to finish.