How does the POISSON.DIST function (DAX) work?

The POISSON.DIST function (DAX) calculates the Poisson probability mass function.

POISSON.DIST Formula Syntax


How do you use the POISSON.DIST function?

A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.

Related Blog Posts

Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

Considerations when using the POISSON.DIST function

If x is not an integer, it is rounded.

If x or mean is nonnumeric, POISSON.DIST returns the #VALUE! error value.

If x < 0, POISSON.DIST returns the #NUM! error value.

If mean < 0, POISSON.DIST returns the #NUM! error value.

POISSON.DIST is calculated as follows.

For cumulative = FALSE:


For cumulative = TRUE:


Related Video Tutorials

Formula examples using the POISSON.DIST function




Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide