Filtering table by Duplicated ReservationNumber

[XAVICHETAPIA]

Dear,

I'm trying a simple measure but first I need to know how to filter a table.

In the table each "NumReservation" has many rows, all with the same "Lead" value.

TABLE:

I would need to filter the table giving only a row by "Numreservation".
Like this.

WANTED TABLE

WANTED TABLE = FILTER ( TABLE,  ???   )

Thankyou in advance,

Xavichetapia 

[mh2587]

Duplicated ReservationNumber=
CALCULATE (  COUNT (
		[Numreservation]
	),
	FILTER (
		Dim_Employments,
		[Numreservation] = EARLIER (
			[Numreservation] 
		),FILTER ( Dim_Employments, [Lead] = EARLIER ( [Lead] ))


      )
)

[XAVICHETAPIA]

Dear,

I found an error when using the EARLIER function.  

I attached the pbix.

https://drive.google.com/file/d/1u9IDBpijtJVKtHLYnQlgEq8MI9yWJx0f/view?usp=sharing

My table is called KPI.

thks

[v-easonf-msft · Accepted solution]

Hi, @XAVICHETAPIA 

You need create a column with a unique index in ‘Transform Data’  first.

(The column 'KPI'[indice] in the example you provided seems to contain duplicate values.)

Then you can create measure like:

Measure =
VAR min_indice =
    CALCULATE ( MIN ( 'KPI'[indice] ), ALLEXCEPT ( 'KPI', 'KPI'[NumReserva] ) )
RETURN
    IF ( SELECTEDVALUE ( 'KPI'[indice] ) = min_indice, 1, 0 )

And drag this measure to visual filter pane to filter data as below:

Best Regards,
Community Support Team _ Eason

[mh2587]

I got this , it suits or not