Funnel Plot Baseline bug?

[carlol]

I installed the Microsoft Funnel Plot add in https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381066?tab=Overview

Looking at the Code and the sample Report the baseline is Calculated Occurrence / Population 

When I add in my Data , for some reason it Calculates as 78.8 

2561 / 3554 = 72%

Anybody come across this? 

Sample report 

https://visuals.azureedge.net/app-store/powerBI-Visuals-funnel.RHTML_FUNNEL_978302916642.1.0.3.0.pbi...

This Calculates the Baseline correctly , 15012/85176762 = 0.00176

Code -- Line 172

https://github.com/microsoft/powerbi-visuals-funnel/blob/master/script.r

[v-xuding-msft]

Hi @carlol ,

As the code shown, the baseline is not just calculated by Occurrence / Population.  As the data is more large, the result will be more accurate. There are some blogs that you can reference to understand clearly about Funnel Plot.

https://www.mssqltips.com/sqlservertip/5973/power-bi-funnel-plot-for-outliers-detection/

https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using...

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[carlol]

It is Calculating the weighted mean vs the Mean

A weighted mean is a kind of average. Instead of each data point contributing equally to the final mean, some data points contribute more “weight” than others. If all the weights are equal, then the weighted mean equals the arithmetic mean (the regular “average” you’re used to). Weighted means are very common in statistics, especially when studying populations.

[carlol]

Link to PBIX

https://1drv.ms/u/s!Ao-FTTt3GMhrh_NJBHWbqlscCdXKKA?e=GuZhzR