How I can not sum up whole Column values

[The8]

Hello,

I will try to explain my problem with sample data.

I have two tables 

Table 1 and 2 with three columns respectively

Table 1=Date, Person ID, Quantity (Available)

table 2=Date, Person ID, Quantity (Utilised)

When I use matrix visualisation  the output will be as follows for individual table

Table 1 Matrix=

 Table 2 Matrix =

I have created a relation berween two tables by using Person ID and I have created the matrix as follows

Combined matrix: 

Here in the above matrix the column sum of quantity utilised is showing sum of person quantity but here i want to show the values sum of quantity per person in that particular month i.e as like the column 2 in Table 2 matrix.

can we do this using DAX or do we have any other solution. 

Thanks in advance
@selimovd @amitchandak @AbbasG 

[amitchandak · Accepted solution]

@The8 , You need to create common Date and Person table and join both tables with that and analyze the data

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw