Mode - Single Column 02-15-2018 12:36 PM - last edited 06-27-2018 13:38 PM

[Greg_Deckler]

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