Merging two pbix files results in summarized data giving wrong result

[nsa]

Hi there,

I am new to Power BI, any advice/solution on this problem is much appreciated.

I am having two pbix files "file1" and "file2" pointing to different products "A" and "B" respectively. They have a very similar dataset with slight changes in SQL query WHERE condition and with different calculated columns and measures, so I have kept the datasets different for both.

I have copied the dataset(including measures and calculated columns) from file2 pointing to product "B" to file 1 and all the data coming through is accurate. I also copied and pasted the visual from original file2 to target file1 as I want file1 to have visuals for both the products. I have pointed visuals to use the new copied dataset in file1 (this is essentially the same dataset in file2 with no difference).

However, my visual displays wrong data now. The data is summarized for all the month and year. For instance, product "B" is new product and it doesn't exist before October 2021 and for October 2021 there are 8 accounts, for November 2021 there are 24 accounts, so total as of November 2021 should be 32 however my visual shows aggregated data value of 32 even for Oct 2021, Sep 2021, Aug 2021 and so on, it shows as if product "B" is existing from 2017 which is not the case. All the filters, DAX expressions, calculated columns etc. remains same, it's just copy paste of dataset and visuals from one file to another. 
Please find the attached visualization files.

TIA

Right Data of Product "B" in Original File 2Wrong Data of Product "B" after combining in Target File 1

[nsa]

Relationship between the tables was not the same. It worked after changing the relationship.

[smpa01]

@nsa  one of the many things can go sideways are, when you change your dataset, the ordering of the column changes which can make things go north. I had this issue when I changed the data source in Query1 from sourceA to a very similar sourceB.

The original order 

<col1>,<col2>,<col3>

got reordered as

<col3>,<col1>,<col2>

Check that is not the case with you and if yes, check the here , worked for me.

[ebeery]

@nsa dumb question, but have you confirmed that the axis on your visualization is on the same level (Year, Month, Day) of the hierarchy?

[nsa]

@ebeery I set the axis on the same level, even then the target file and original file is not displaying same data. I have agreegated data in target file which is same for all the months in target file.

[ebeery · Accepted solution]

@nsa and have you confirmed that the relationship to the Calendar table is the same between both models?