02-15-2018 12:36 PM
- last edited
06-27-2018 13:38 PM
Imagine you have a table of data with multiple columns like this...
...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])
This quick measure would take as input a column in which to calculate the mode.
Proud to be a Super User!