Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
CScottP
Regular Visitor

Filter by column "Unit" to get filter "Highest " value

‎02-03-2025 08:14 AM
UNITVALUE 
A0 
A1 
A2 
B0 
B1 
B2 
C0 
C1 
C2 
C3 
D0 
D1 
D2 
D3 
D4 
D5 
D6 

 

Expected reults:
A2
B2
C3
D6
Message 1 of 3
203 Views
0
1 ACCEPTED SOLUTION
Syk
Super User
Super User

‎02-03-2025 08:21 AM

Max Value = MAX(Table[Value])

Syk_0-1738599660949.png

 

View solution in original post

Message 2 of 3
197 Views
2 REPLIES 2
vivek31
Resolver II
Resolver II

‎02-03-2025 09:48 AM

HI @CScottP ,

you can you use MAX function 
Highest = MAX(Table[Value])

Message 3 of 3
157 Views
Syk
Super User
Super User

‎02-03-2025 08:21 AM

Max Value = MAX(Table[Value])

Syk_0-1738599660949.png

 

Message 2 of 3
198 Views

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All