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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
peterso
Helper II
Helper II

Return MIN value based on group

Hi all,

 

Having some trouble with this... I'd like to add a measure to a visual that will allow me to plot the cost based on the minimum value for each type. 

peterso_0-1614000272640.png

 

Thanks in advance.

1 ACCEPTED SOLUTION

7 REPLIES 7
jameszhang0805
Resolver IV
Resolver IV

jameszhang0805_0-1614002135673.png

 

@jameszhang0805 Nice solution, a suggestion if you don't mind, use aggregation function such as MIN/MAX instead of VALUES to prevent the code from breaking in case there are duplicate Value for Type 🙂 

@AntrikshSharma Thanks for your suggestion, you are correct. 

jameszhang0805_0-1614003480931.png

 

Sorry I should have specified - I would like to only keep the rows that include the highlighted cost. Is this possible?

just remove the filer(all(Table)),from the calculate argument

I received an error when adding the measure to a visual "A table of multiple values was supplied where a single value was expected"

jameszhang0805_0-1614012575229.png

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.