DAX computation for Bell Curve

[polaris3028]

Hi All, need your help.

I'm trying to figure out how to create a measure to compute for a bell curve.

Say:

Developer	Tasks
Dev 1	58.25
Dev 2	21.00
Dev 3	12.00
Dev 4	8.00
Dev 5	6.00

I need to create a column that would tell me what's the bin a bell curve that the a Dev is in. 

Given that:

5 = Task volume in top 5% of bell curve 4 = Task volume in upper 15% of bell curve 3 = Task volume in middle 60% of bell curve 2 = Task volume in lower lower 15% of bell curve 1 = Task volume in bottom 5% of bell curve

[TomMartens]

Hey,

maybe this gets you started:

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

Regards

Tom

[polaris3028]

Thanks, Tom.  I'll give it a shot.