Forum Discussion
Filtering table by Duplicated ReservationNumber
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
Duplicated ReservationNumber=
CALCULATE ( COUNT ( [Numreservation] ), FILTER ( Dim_Employments, [Numreservation] = EARLIER ( [Numreservation] ),FILTER ( Dim_Employments, [Lead] = EARLIER ( [Lead] ))
) )
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
I got this , it suits or not
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
