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...
Need Help
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?