Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Get max repeated value in column

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

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

 

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

Here is a demo.

It shows as below:

68.png

 

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

 

Best Regards,
Community Support Team _ Eason

 

View solution in original post

3 REPLIES 3
v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

 

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

Here is a demo.

It shows as below:

68.png

 

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
Super User
Super User

@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
Post Prodigy
Post Prodigy

Try following measure:

 

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

 

change YourTable .

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.