Poisson.Dist not calculating as expected

[SarahESkells]

Hello

I am trying to use the poisson.dist function in Power BI desktop, however using it as a calculated gives an incorrect result and as a measure doesnt allow me to select the column for x value.

The formula should be (for row 1) poisson.dist(0,3.26,false), for row 2 poisson.dist(1,3.26,false) etc, however the "column" doesnt give the expected output and the measure wont let me use column FT TG as its not a measure but gives the right output if I put in x = 0 for the first row?

Any help will be hugely appreciated

Thanks in advance

[v-zhangti]

Hi, @SarahESkells 

You can try the following methods.

Measure = poisson.dist(SUM('Table'[FT TG]),SUM('Table'[All Teams]),FALSE())

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[SarahESkells]

Thank you for this, it doesn't like it because the All Teams is also a measure? Is there anyway around this?

[v-zhangti]

Hi, @SarahESkells 

Sample data:

Measure:

All Teams = CALCULATE(SUM('Table'[Teams]),ALL('Table'))

Measure = poisson.dist(SUM('Table'[FT TG]),[All Teams],FALSE())

Does this match your situation?

Best Regards,

Community Support Team _Charlotte

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

[SarahESkells]

Hello, thank you for your help.

The All Teams is 

All Teams = CALCULATE(sum('Table'[FT TG]),ALLSELECTED('Table'))

/CALCULATE(count('Table'[HomeTeam]),ALLSELECTED('Table'))

and the FTTG when used in the poisson.dist i don't want it used as a sum because in the table of data it there will (for example) be multiple FTTG = 1, but the poisson dist should use x = 1 not the sum of the 1's.

Hopefully that makes sense