Forum Discussion

Frequent Visitor

4 years ago

Solved

Filtering table by Duplicated ReservationNumber

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

v-easonf-msft
4 years ago
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

4 Replies

mh2587
Super User
4 years ago
Duplicated ReservationNumber=
CALCULATE ( COUNT ( [Numreservation] ), FILTER ( Dim_Employments, [Numreservation] = EARLIER ( [Numreservation] ),FILTER ( Dim_Employments, [Lead] = EARLIER ( [Lead] ))

) )
- XAVICHETAPIA
  Frequent Visitor
  4 years ago
  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
  - mh2587
    Super User
    4 years ago
    I got this , it suits or not

Related content