show lowest value item in a card

[Anonymous]

Hi Guys, 

I am trying to find make a card show the supplier by lowest cost when filtering to a certain item. 

I.e. when i filter to item A, I expect the card to show supplier one.  Is this a topN dax function? I could not understand the other thread similiar to this. Please advise and appreciate any help provided. Cheers. 

Item	state	Cost	Supplier
A	NSW	1	one
A	QLD	1.5	two
A	TAS	2	three
B	NSW	3	one
B	VIC	4	two
C	NSW	5	one
C	QLD	4	two
C	TAS	6	three

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this MEASURE

Measure =
CONCATENATEX ( TOPN ( 1, Table1, [Cost], ASC ), [Supplier], ", " )

[Anonymous]

Thank you kind sir, worked like a charm.