show the first row where the measure is minimum

[jaweher899]

I've a table like

Originator	Client_Name	CF_ZK	CF_SH	CF_GOS	CF_EFY	Origination Credit USD
EFY	aaa	20			40	$1073
SH	bbb	13.33	40		20	$4451
NS	vvv	6.67	80			$1798
NS	ccccc	6.67	80			$1798
ZK	xxx	6.67	80			$899
ZK	vgrgtg	6.67	80			$899

I'd like to show the first row where Origination Credit USD is minimum,

The expected results in the table should be 

ZK

xxx

6.67

80

$899

Is there a way to do it?

[v-stephen-msft · Accepted solution]

Hi @jaweher899 ，

For the requirement of showing first row, you need to add an index column in Power Query.

Then go back to Power BI Desktop and create the following two measures.

Index of MinUSD =
IF (
    SUM ( 'Table'[Origination Credit USD] )
        = MINX ( ALLSELECTED ( 'Table' ), [Origination Credit USD] ),
    SUM ( 'Table'[Index] )
)

FirstRow =
IF (
    MINX ( ALLSELECTED ( 'Table' ), [Index of MinUSD] ) = SUM ( 'Table'[Index] ),
    1
)

Put the "FirstRow" meausre into the visual-level filters and set up show items when the value is 1.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.