Making Lognorm.inv DAX run faster

[matsahiro]

Hello, I wrote this DAX calculating the inverse of a logarthmic normal distribution. DAX seems to be running very slow as there are about 10K records to calculate this for. Any tips on making it run faster? Thanks

LogNorm.Inv =

Var

    Sigma = sqrt(ln(1+50*power(sum(Table[Table_Column]),-.9)))

Var

    Mu = iferror(LN(sum(Table[Table_Column]))-DIVIDE(Power(Sigma,2),2),"")

Return

    IFERROR(EXP(Mu+Sigma*NORM.S.INV(Parameter)),"")

[lbendlin · Accepted solution]

Have you looked at the query in DAX Studio?  I would assume it lives entirely in the formula engine, but maybe there are some hints as to which part of the query you can cover with lookup tables.

You do error handling for the Mu part but then you ignore that again and brute force the inclusion of Mu on the return step.  You can replace that with a conditional calculation.

Please provide sample data in usable format (not as a picture) and show the expected outcome.