Divide numbers on probability

[Anonymous]

Hello, I am trying to group and divide some values in different tables. I attached pbix file. 

There are a few campaigns with values and blank value (called other). I want to divide these "other" values to other campaigns. Other values are 2. One is should with "campaign 1" and second should be split into other values. 

Why 1000 below? I count campaign 2-6 = 1000 and I divided them by percentage - it is how "probably" they lead. So it is not clear numbers, but only with probability. Most leads in the campaign - most percent from unknown campaign.

Hope, it is a little clear

BTW not sure, if it is the right way to divide unknown numbers.

Thanks in advance   

Result should be:

Name	Leads
Campaign 1	100 + 300 (from second table)
Campaign 2	200 + 20% from1000
Campaign 3	150 + 15% from 1000
Campaign 4	200 + 20% from 1000
Campaign 5	250 + 25% from 1000
Campaign 6	200 + 20% from 1000

[v-lili6-msft]

hi  @Anonymous 

1. why campaign 2-6 will add 1000 2000 3000 4000 5000 6000, what is the logic of it.

2. what is the logic of this percent, just a random percent between 0% and 100%?

Regards,

Lin

[Anonymous]

My mistake - divide should be number 700 instead of 1000

Number 1000 - is sum of campaign 2 to 6

I divided those campaigns by success. Then I want to divide number 700 (table: calls - other "other 2" - value 700) by percentage.

Thanks and sorry

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format?

few ways to get information from 1 table to another in a column

1-M related tables (From 1 to M) //new column Sales

Item Name = RELATED('item'[Brand])

//On Sales Side. But both side of the join is poosible

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City])

//In sales

Month Name = LOOKUPVALUE('date'[Month Year],'date'[Date],Sales[Sales Date])

[Anonymous]

Hello @amitchandak , thanks for your reply. Here is excel file.