Exporting Underlying Data join not working

[VCQ]

Hello!!

I believe I know why this problem is occuring but I just wanted to double check. Below both column A and F are joined. My date table joined to my data table. It seems as though when i export the underlying data on a visual it pulls back rows where the join does not seem to be functioning correctly. Fortunatley the measures are not calcuting on those rows. 

Is this because I am using the date key from both tables somewhere in the visual/measures and its just pulling back all of the combinations of those values?

[v-yuezhe-msft]

@VCQ,

Do you use "Summarized data" option or "Underlying data" option? Could you please share dummy data of your data table and describe more details about what fields of which tables you use to create the visual?

Regards,
Lydia