Mode - Single Column

Greg_Deckler — Wed, 27 Jun 2018 20:38:31 GMT

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

topic Mode - Single Column in Quick Measures Gallery

Mode - Single Column