Forum Discussion
Standard Deviation Formula does not generate group stdev in table
Hey all,
My standard deviation measure does not give me the standard deviation of each group, only a total when I put it into a table. How come? Formula and pics below:
stdev_project_invoice = STDEVX.P(SUMMARIZE(DimProject,DimProject[DimProjectName],"Invoice Values",[Total Invoices]),[Invoice Values])
stdev_project_subtype = STDEVX.P(SUMMARIZE(DimProject,DimProject[DimProject SubTypeName],"Invoice Values Subtype",[Total Invoices]),[Invoice Values Subtype])
2 Replies
v-chuncz-msft Thanks man, How would you suggest using the ALLSELECTED within the formula?
