Forum Discussion

Daniel_Enum's avatar
Daniel_Enum
Regular Visitor
4 years ago
Solved

Measures dont drill down correctly

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.