Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
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