Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Mapping

I have 2 different datasets with bunch of records. Table 1: Items, Item Received Quantity, Vendor Table 2: Items, Item Defect Quantity, Vendor   Expectation is to get table (visualization) for Ve...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    For your requirement, you'd better create a data model as below:

    Create two fact tables that a distinct list of vendor and a distinct list of item.

    Then relationship like this:

     

    Then when you create report, use Vendor and Item from Vendor table and Item table.

     

    Best Regards,

    Lin

d_gosbell's avatar
d_gosbell
Super User
7 years ago

The best way to do this is to create a 3rd table that is a distinct list of Vendors. Then create a 1 to many relationship between this table and tables 1 & 2. Then when you drag the Vendor name from this new table you should be able to drag the Item Received Quantity and Item Defect Quantity from the other 2 tables and it should "just work".

 

PS. If you do this I would also recommend hiding the "Vendor" column in tables 1 and 2 as using either of those will lead to the incorrect results you are currently seeing.