Distribution of a value from one table to other

[Anonymous]

Hi Guys,

I have two tables which are related to each other but number of rows are different. 

Table 1 : 

This table has multiple rows with campaign and adgroup combinations. And I have table 2 which has columns device,search engine,advertising type,language,location,primarylist and target value. 

I want to distribute value from table 2 to table 1. For example : first row in table 2 represents for AUS, EN, GO,SER,Desktop,BLK and 01/01/2018 we have target value as 2605.71 and for the same combination in table1 we have 3 rows (top 3 rows) and I want each row in table 1 to have target value which will be 2605.71/3 = 868.57.

[v-chuncz-msft]

@Anonymous,

You may refer to the following post.

http://community.powerbi.com/t5/Desktop/Calculate-measure-for-sum-for-each-day-in-month/m-p/233072#M103820

[Anonymous]

@v-chuncz-msft

I understand the solution that you have shared but the problem is I have different other filters as well. How do i match those values from table 2 to table 1?