cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikyi_ro Helper I
Helper I

Key Influencer - likelihood calculation not matching

HI there,

I've created this Key Influencers visual but don't figure out the calculation for the likelihood. 

The green bar is at 1.35% (2747)

Average is 0.78% (36548)

 

The likelihood plotted is at 1.82x.  it's not 1.35 / 0.78...

There are no blanks or nulls in the column feeding the Explain by filed...

What am I missing ?

 

Thank you

 

Capture5.PNG

 

 

9 REPLIES 9
Community Support
Community Support

Re: Key Influencer - likelihood calculation not matching

Hi mikyi_ro,

The likelihood seems not equal to green bar /red line(it approximately equal) , it seems that it has its algorithm. You alo could refer to Key influencers visualization(you will see the likelihood  also not equal to gren bar /red line). I will discuss with other engineers about this algorithm, and I will inform you as soon as i get it.

Best Regards,
Zoe Zhi

mikyi_ro Helper I
Helper I

Re: Key Influencer - likelihood calculation not matching

OK, Dax, thank you,

will wait for the feedback from the engineers

thanks

Olimpiusz
Regular Visitor

Re: Key Influencer - likelihood calculation not matching

Any news on that one? I'm also very interested in this topic. Thanks!
Olimpiusz
Regular Visitor

Re: Key Influencer - likelihood calculation not matching

On Misrosoft page you wrote that:

Screenshot_20190821-200059_Chrome.jpg

So how we should interprete that?

PJ-292
Frequent Visitor

Re: Key Influencer - likelihood calculation not matching

were you able to solve this? i'm having the same trouble of the likelihood figure not matching up too. 

Olimpiusz
Regular Visitor

Re: Key Influencer - likelihood calculation not matching

still waiting for answers.. how can we use it well if we do not know the basics.. 😉

mikyi_ro Helper I
Helper I

Re: Key Influencer - likelihood calculation not matching

Hello all,

 

After some more digging, I understood that the visual takes a sample of 10k rows to build the analysis on. So if you load less than 10k rows, the division should work out, if more than 10k in the data, the sampling (stratified sampling) will grab the most representative 10k only and this is why the division will not match.

 

Thanks all,

Mihnea

Olimpiusz
Regular Visitor

Re: Key Influencer - likelihood calculation not matching

Och! Thank you for pushing me in this direction. How did you notice that? Any Microsoft article or just an assumption?

Highlighted
Paulina
Frequent Visitor

Re: Key Influencer - likelihood calculation not matching


@mikyi_ro wrote:

Hello all,

 

After some more digging, I understood that the visual takes a sample of 10k rows to build the analysis on. So if you load less than 10k rows, the division should work out, if more than 10k in the data, the sampling (stratified sampling) will grab the most representative 10k only and this is why the division will not match.

 

Thanks all,

Mihnea


Hi,

 

How did you learn about that? Can you please recommend any article explaining how stratified sampling is performed in Power BI? 🙂

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors