filtrar el ultimo Event Change ID

[paulpena78]

Hola a tod@s,

En esta oportunidad agradezco cualquier ayuda para este requerimiento:

• Segun la tabla de la  imagen deseo que solo se muestre el ultimo EV_CHANGE_ID que se haya generado segun el EVENT_ID.

[PaulDBrown]

Ok. Try:

Último =

VAR Ult = CALCULATE(MAX(Table[EV_CHANGE_ID]), ALLEXCEPT (Table, Table [EVENT_ID]))

RETURN

COUNTROWS (SUMMARIZE(FILTER(Table, Table[EV_CHANGE_ID = Ult), Table[EV_CHANGE_ID], Table[EVENT_ID]))

add the measure to the filter pane and set the value to equal 1

[paulpena78]

Hi @PaulDBrown ,

Please Please Apologies!!!!! but not working:

I'm add the measure in Filter panel and set the value to equal 1 but show all items:

[paulpena78]

Hi @PaulDBrown Good Morning,

Can you help me?

Thanks. 

[PaulDBrown · Accepted solution]

I've just tested both solutions posted and they work for me

I've attached the sample PBIX file for you

[PaulDBrown]

Apologies! Try:

Último =

VAR Ult = CALCULATE(MAX(Table[EV_CHANGE_ID]), ALLEXCEPT (Table, Table [EVENT_ID]))

RETURN

IF(MAX(Table[EV_CHANGE_ID]) = Ult, MAX(Table[EV_CHANGE_ID]))

[paulpena78]

Hi @PaulDBrown 

I'm sorry but no working, I want this result:

[PaulDBrown]

Prueba:

Último =

VAR Ult = CALCULATE(MAX(Table[EV_CHANGE_ID]), ALLEXCEPT (Table, Table [EVENT_ID]))

RETURN

IF(MAX(Table[EV_CHANGE_ID]) = Ult, Table[EV_CHANGE_ID])

[paulpena78]

Hi @Paul ,

I have a message error:

Thank you.