Forum Discussion

mitchellericio's avatar
mitchellericio
New Member
2 years ago

average, std deviation and Z statistic

Hi Experts,   I am trying to do some analysis on volumes per headcount on our data. Put in the DAX measures but somehow it is not agreeing with the manual formula checks am doing.  Currently the da...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  mitchellericio ,

 

Are you referring to customizing the values based on the Column of the matrix, which you can do with the Switch function.

Measure =
SWITCH(
    TRUE(),
    MAX('Table'[Manual])="Zstat",1,
    MAX('Table'[Manual])="Quote/HC",2,
    MAX('Table'[Manual])="AvgQuotes/HC",3,
    MAX('Table'[Manual])="Zstat",4)

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.