# Power Pivot Principles: The A to Z of DAX Functions – EXPON.DIST

17 October 2023

*In our long-established Power Pivot Principles articles, we
continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at EXPON.DIST. *

* *

*The ***EXPON.DIST ***function*

In probability theory and statistics, the exponential distribution (also known as negative exponential distribution) is the probability distribution that describes the time between events in a Poisson point process. That’s good if you know what that is! This is a process in which events occur continuously and independently at a constant average rate. It is a particular case of the probability distribution known as the gamma distribution. It is also the continuous analogue of the geometric distribution, and it has the key property of being memoryless. In addition to being used for the analysis of Poisson point processes, it is also found in various other contexts.

It should be noted that the exponential distribution is not the same as the class of exponential families of distributions, which is a large class of probability distributions that includes the exponential distribution as one of its members, but also includes the normal distribution, binomial distribution, gamma distribution, Poisson and many others.

The **EXPON.DIST **function** **is one of the statistical
functions where it returns the exponential distribution. It has the following syntax:

**EXPON.DIST(x, lambda, cumulative)**

It has three [3] parameters:

**x**: this is required and, it represents the value of the function**lambda**: this is required and, it represents the parameter value**cumulative**: this is also required and, it represents a logical value that indicates which form of the exponential function to provide. If cumulative is TRUE,**EXPON.DIST**returns the cumulative distribution function; if FALSE, it returns the probability density function.

It has the following remarks:

- if
**x**or**lambda**is nonnumeric,**EXPON.DIST**returns an error message - if
**x**or**lambda**is not an integer, it is rounded - if
**x**< 0,**EXPON.DIST**returns an error message - if
**lambda**≤**0, EXPON.DIST**returns an error message - the equation for the probability density function is:

- the equation for the cumulative distribution function is:

- This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Let’s consider the following example where we have a **Data **table with a **Variables** column:

We can write the following DAX code to calculate the probability density function here:

Similarly, we changed the last argument of **EXPON.DIST **function into TRUE for cumulative distribution function:

After this we will put the measure on the PivotTable to view
the result with **Variables** as a Rows field and the two measures as Values
fields:

*Come back next week for our next post on Power
Pivot in the **Blog** section. In the meantime, please remember we have
training in Power Pivot which you can find out more about **here**. If you wish to catch up on past articles in
the meantime, you can find all of our Past Power Pivot blogs **here**.*