Extract Minimum Value excluding zero in EXCEL

[Ellisa2255]

Brand	Model	Price
Toyota	Corolla	0
BMW	E24	100,000
Toyota	Camry	120,000
Toyota	Yaris	80,000

Good day. Kindly assist...

I have an auction sale data set similar to the one above. I am using excel 2013 and I want to extract the minimum price of the Car Brands excluding zero(s)-using DAX. In that way, for Toyota I can have 80,000 as the minimum price instead of 0. 

Your help is much appreciated.

Thank you.

[#2 · Accepted solution]

@Ellisa2255 

If that's data model table the measure could be

min Price:=CALCULATE(MIN(Table1[Price] ), Table1[Price] > 0 )

[#3]

Thank you very much.

[#4]

@Ellisa2255 

You are welcome

[#5]

Good Afternoon
How would I go about extracting data from sheet 1 to sheet 2 if cell value greater than 0
I'm trying to create a weekly price list (Sheet 2) of available (>0) items from a master list (Sheet 1).

ID #	Name	Grade	Description	Size	Cost	Price	Available
	OG Bounce Mushroom	ULT	Original bounce	2”	$25.00	$32.50	1
	OG Bounce Mushroom	ULT	Original bounce	1”	$16.00	$20.80	0
	OG Bounce Mushroom	ULT	Original bounce	½"	$12.00	$15.60	4
	Spiderman Bounce Mushroom	ULT	Blue mushroom w/ bright red/ orange bubbles	2”	$35	$45.50	0
	Spiderman Bounce Mushroom	ULT	Blue mushroom w/ bright red/ orange bubbles	1”	$26	$33.80	0

[#6]

@Pat_Davies 

Depends on your Excel platform / version and what are you going to do with extracted data. As variant that could be FILTER function (microsoft.com)