Forum Discussion

SusuYes's avatar
SusuYes
Icon for Helper III rankHelper III
3 years ago

Calculating the Mode and Median for Non-numeric data

Hello everyone,  I have data on the number of staff who attended certain workshops. I have calculated the average number of attendance to every workshop type. However, I want to calculate the mode...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

SusuYes , Try like

 

Medianx(Values(Table[Workshop Type]), calculate(Count(Table[Staff ID])) )

 

 

Averagex(Values(Table[Workshop Type]), calculate(Count(Table[Staff ID])) )

SusuYes's avatar
SusuYes
Icon for Helper III rankHelper III
3 years ago

Hello amitchandak, 

 

thanks for your response. I tried the above formulas but for the Medianx I got the result back to be 1 which is not quite right. I am expecting to know for each workshop type, what is the median value of the number of staff that attended.