Values and Grandtotal does not match

Hello,

I have a problem with my data modelling. I have more than 1 source querry one of them consisting of invoice amount and invoice due days etc. another one which i created as a DIM table is Date Table.

I created a relatinship between my source querry and date table. (many to one and both directioned)

In that date table i created calculated column called Period_2 as seen below.

when i create a visual table on pbi (as seen below) , not every period 2 has value across it. for instane 2019_12 should have had 30.250 euro but it does not show it in table but its in grandtotal of 73.930. 

On the other hand when i am using Period_2 from the main dataset (source querry) 2019_12's value is appearing but then it brings all the years in the data set eventho they are all blank. In short i want to use Period_2 from date table but i want it to show correct values. 

I dont know where i am doing the mistake. please help 😞