Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

 

 

Need Help

9 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    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

    • Olimpiusz's avatar
      Olimpiusz
      Frequent Visitor
      7 years ago

      On Misrosoft page you wrote that:

      So how we should interprete that?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      OK, Dax, thank you,

      will wait for the feedback from the engineers

      thanks

  • Olimpiusz's avatar
    Olimpiusz
    Frequent Visitor
    7 years ago
    Any news on that one? I'm also very interested in this topic. Thanks!
  • PJ-292's avatar
    PJ-292
    Frequent Visitor
    6 years ago

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

    • Olimpiusz's avatar
      Olimpiusz
      Frequent Visitor
      6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Anonymous 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? :)

    • Olimpiusz's avatar
      Olimpiusz
      Frequent Visitor
      6 years ago

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