cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Divide numbers on probability

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.

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
4 REPLIES 4
Highlighted
Super User IX

## Re: Divide numbers on probability

@tomasmartinek ,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])

Proud to be a Super User!

Highlighted
Helper I

## Re: Divide numbers on probability

Highlighted
Community Support

## Re: Divide numbers on probability

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper I

## Re: Divide numbers on probability

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

Announcements

#### Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021