Get max repeated value in column

[Anonymous]

Hi all,

i have a column in which values are like a,b,c,d,...and these values are repeating in nature. i want to see a variable which has highest count.

Let me how would it be possible.

TIA

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

It seems that @rajendraongole1  solution should meet your requirements if  i understand correctly.

Here is a demo.

It shows as below:

If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous 

Create a rank  measure

rankx(all(Table[Category]),calculate(sum(Table[Value])),,desc,dense)

use 1 as a filter in visual on rank measure. Please refer my blog, where this has been done : https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814

Appreciate your Kudos.
Proud to be a Datanaut Connect on Linkedin

[rajendraongole1]

Try following measure:

Max_Count =MAXX ( VALUES ( YourTable[ID] ), CALCULATE ( COUNTROWS ( YourTable ) ) )

change YourTable .