cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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:

NameLeads
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
4 REPLIES 4
Highlighted
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!

Highlighted
Helper I
Helper I

Re: Divide numbers on probability

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

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

 

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

Announcements
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.

secondImage

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