How to Calculate the Most Frequent Value of a Measure

In this tip, I show you how to use both a level of detail expression and a table calculation to compute the most frequent value in a measure.

First, I show you how to return this as a histogram as well as a single number.

By the end of this tip you will be able to calculate the most frequent quantity ordered. This same process could be used, for example, to compute the most frequent discount.

[itzmee]

Andy you are such an amazing resource of Tableau. Now iam a certified Associate with all your work.

[krugerdw]

Always love your videos - thank you Andy

[michelnahon]

Great hack Andy. Usually, I prefer LOD since one can control all dimensions. Any benefit from using a table calculation here?

[aleksanderostasiuk]

Hello Andy, how we can show modal value (dominant) for this example. In this case it should be 3, 00 (becasuse it was the most frequent value - 2, 409 appearances)

[Jay.]

Never imagined a measure can be inside an LOD !!

[dhssb]

Hi, Andy. For the third method which in sheet3, I followed your step exactly but didn’t get ‘9994’ where you get, instead I got ‘14’. Could you please what’s going wrong?