Mode - Single Column

Imagine you have a table of data with multiple columns like this...

 

Column

A
B
C
A
B
C
A
A
A
B
B
C

 

...and you wish to figure out what value occurs most often in that column. You can use a measure like this:

 

 

Mode = VAR myTable = SUMMARIZE(Table,Table[Column],"Count",COUNT(Table[Column]))
VAR myTable2 = FILTER(myTable,[Count]=MAXX(myTable,[Count]))
VAR Mode1 = MAXX(LASTNONBLANK(myTable2,[Column]),[Column])
RETURN Mode1

 

This quick measure would take as input a column in which to calculate the mode.

 

 

eyJrIjoiOWM1ZDE0MzQtZTliNC00NGMyLTg5MmYtZWFjZTg4MTM2N2IzIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9