DAX computation for Bell Curve

Question

Hi All, need your help.&nbsp;I'm trying to figure out how to create a measure to compute for a bell curve.&nbsp;Say:DeveloperTasksDev 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 58.25Dev 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21.00Dev 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.00Dev 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.00Dev 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6.00&nbsp;I need to create a column that would tell me what's the bin a bell curve that the a Dev is in.&nbsp;&nbsp;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 · Answer

Hey,&nbsp;maybe this gets you started:https://www.mssqltips.com/sqlservertip/4076/create-bell-curve-and-histogram-with-power-bi-desktop-using-dax/&nbsp;RegardsTom

polaris3028 · Answer

Thanks, Tom.&nbsp; I'll give it a shot.

Forum Discussion

DAX computation for Bell Curve

2 Replies

Related content

Bell curve DAX

S - Curve

Bell Curve visualization

Bell curve chart

Creating Bell Curve using DAX

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