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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Write these measures.  Based on that data that you have shared, please share the exact values that you are expecting of the Mode.

Attendees = SUM(Data[Staff ID Attended])
Median = MEDIANX(VALUES(Data[Staff ID Attended]),[Attendees])

Hope this helps.

 

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

Hello Ashish, thanks for your suggestion but unfortunatly my Staff ID coloumn is stored as a string so I cannot sum it. Any idea how to get across that? 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    You are welcome.  In which case, is your question even relevant?  I thought arithmatic functions (specially Median and Mode) work only on numeric columns.

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

      Hello Ashish, I am hoping to report on the number of attendees to each workshop type and finding the median, mean, and mode of the attendance for each workshop type. 


      Would using a count for Attendees serve the same purpose? 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Just show the exact result you are expecting.