Showing results for 
Search instead for 
Did you mean: 
Helper I
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.


Thanks in advance   


Result should be:

Campaign 1100 + 300 (from second table)
Campaign 2200 + 20% from1000
Campaign 3150 + 15% from 1000
Campaign 4200 + 20% from 1000
Campaign 5250 + 25% from 1000
Campaign 6200 + 20% from 1000
Super User IX
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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helper I
Helper I

Re: Divide numbers on probability

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

Community Support
Community Support

Re: Divide numbers on probability

hi  @tomasmartinek 


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%?




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.
Helper I
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

Helpful resources

Community Conference

Power Platform Community Conference

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

Upcoming Events

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

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors