Need a help with creating range of Values to find Probability.

[Anonymous]

Hi, I am a new user of DAX.  Could you please help me with the following problems.

I am trying to get  Probability (Poison Distribution) based on the Item ID for a given range of values. For Example,  itemID 123, there is 10%  probability values fall between 10 to 15. 

I used the following formula. But it is picking a range of values from 0 to Given value.  Need something like a Poison Distribution Column. 

ItemsID	BID($)	Poison Distribution Probability
123	5	10%
123	15	10%
780	9	15%
780	10	15%
992	15	10%
992	20	10%
100	30	3%
100	32	3%
889	20	1%
155	30	2%
155	35	2%
110	30	17%
110	32	17%

Currently, I am getting this with the following Measure formula.

Prob = POISSON.DIST(10;[MEAN2];TRUE)

Thank you in anticipation.

[harshnathani]

Hi @Anonymous ,

Not sure but , Check if these help

https://www.youtube.com/watch?v=OONJNyiDhGQ

https://www.youtube.com/watch?v=xWva7msu8Yk

https://community.powerbi.com/t5/Desktop/NORMAL-DISTRIBUTION-FORMULA-IN-DAX/td-p/167215

https://www.mssqltips.com/sqlservertip/4076/create-bell-curve-and-histogram-with-power-bi-desktop-using-dax/

Regards,

HN