NORM.DIST Issues

Hi Robert14358 ,

Thanks lbendlin answer , and I have some other suggestions:

The DIST function is designed to use a single value for each calculation, X. If you enter an array or multiple values for X in a single function call, it may not work as expected. For datasets in which X can accept multiple values, you would typically apply the NORM.DIST function to iterate over each value of X separately, either by iterating in a script or by iterating in a column of the computation that handles each row separately.

As for the interaction with filters, calculated columns in Power BI are calculated during data refresh and are not dynamically recalculated when filters are applied in the report. This means that values in calculated columns, such as with the NORM.DIST function, remain static and do not change based on filters applied in the report view. However, metrics in Power BI interact with filters and are recalculated based on the current filter context.

If you observe that the hard-coded value generates the same curve regardless of the filter applied, it is consistent with the expected behavior of the calculated column. For dynamic interactions with filters, consider using metric values instead of computed columns where feasible.

Best Regards,

Xianda Tang

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