Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

calculate maximum likelihood estimate of exponential parameter in measure/use r function in measure

Hi, is there a power bi function i can use in a measure to calculate maximum likelihood estimate of a parameter for an assumed distribution? i want to use it in a measure as i want the flexibility to slice & dice the data & return output as per selection. presumably the measure will capture the filtered data & hopefully there is some way to use a function to compute some statistics from those values.


If there is no such function, is it possible to use a R function within a measure? i am hoping to basically produce the 'estimated parameter' of 2.26 in a matrix as shown in example at bottom of page here by using a function like this:

  eexp(dat, ci=TRUE, conf = 0.9)


any ideas? thanks


Community Support
Community Support

HI @fess440,

Perhaps you can take a look at EXPON.DIST function if it meets your requirement:


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User
Super User

Hi, maybe what if parameters can help you. They let you pick values from and to two values you pick up. They you can use the result of that switcher on your measures to simulate scenarios.

Hope that helps,

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

Happy to help!

LaDataWeb Blog

Super User
Super User

You can probably make a complicated DAX expression to get your result, but if you decide to go the R route, please see this post I wrote a while ago on how to return content from R that is not a visual.


If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.



Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!