Line and Stacked Column Chart/ problem with line display value

[Stofi]

Hi everyone! My problem lies in the Line and Stacked Column Chart. I have imported 2 sheets one with dates/times that I want (Opened - 70) and other one with all dates/times (Total - 1071). Line should show how much was per month instead it is a straight line. Since "Total" is set as date/time why does it show it as total value 1071 and not each number per month?

If I want to create a relationship between these two, it shows up like this. Mind you, that "line" should display over 1000 results. 

Does anyone know how to deal with this? Any help would be appriciated!

[Bijen_Shah]

The issue is that these two sheets (tables) have different row context 

You need a calendar table connecting both these tables on a 1 to Many relation
Then instead of using dates from one of the either tables you use the dates from calendar table and it will filter both tables and give row context for appropriate results.
use = Calendar() DAX function to instantly create a Calendar table

Did I answer your question? Kindly mark my post as a solution!
Appreciate your Kudos! Happy to Help!