Measures dont drill down correctly

[Daniel_Enum]

Hi guys, 
I'm experiencing a weird problem with my graphs. 
I have 2 tables,:
table 1 contains my orders so there is alot of rows with columns of prodcut id, timestamp (date and time) quantity and profit (not shown here).

table 2 contains columns of product id, date and total volume in market in this day.

I want to calculate the sum of my orders /total volume per day and per stock id.

The measure works well only if I use date from table 2 as the date but if I use a dual graph and for example insert profit and orders/volume then the graph breaks.
If I use the timestamp from table 1 then the measure doesn't filters down and showing only 1 value (sum of all)
If I use the date from table 2 then the measure works fine but the profit doesn't filter and stuck on 1 value (sum of all)

what do i need to do make it work? 
I guess something is wrong with how pbi understands the date/time but have no idea how to fix it.

[Ale · Accepted solution]

You have to create a Date table to work as date dimension and then create the relationship between the Date dimensions and your 2 tables. After that, you use the Date from the Date table and the visual will work.

Here you can find how to create this Date table: https://community.powerbi.com/t5/Desktop/Creating-Date-Tables/td-p/553980