Count column and return value that appears most

[rosscortb]

Hello

I am tring to return the numberic value of the most used text value in a column [Exit][Why are you leaving]

Any ideas

tried the max functions but couldn't get it quite work.

Thanks

Ross

[v-yuta-msft · Accepted solution]

@rosscortb ,

Generally, you can first create a calculate column using DISTINCTCOUNT() function to achieve the number of frequency in each text. Then create a measure using MAX() function to get result, for example, the measure may be like pattern below:

Result =
CALCULATE (
    MAX ( Table[Exit] ),
    FILTER ( Table, Table[Calculate Column] = MAX ( Table[Calculate Column] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

You could try the solution provided in this post:

How to obtain the most common value from a column and display it? 

[rosscortb]

thanks, you don't happen to number how return the top value not numeric count but the actual text value. i've only managed to return the text value of the one with the most characters.