Z Scores in DAX

Ive solved this one

If anyone has the same issues i created 4 measures and put them in my table using the all selected function.

Actual Minutes = SUM(‘SAP Last 40 Ship Sets (Hassan)’[Actual Minutes])

Mean = AVERAGEX(ALLSELECTED(‘SAP Last 40 Ship Sets (Hassan)’),[Actual Minutes])

Std Dev = STDEVX.S(ALLSELECTED(‘SAP Last 40 Ship Sets (Hassan)’),[Actual Minutes])

ZScore = DIVIDE(([Actual Minutes]-[Mean]),[Std Dev])

Capture

1 Like