DAX Max value from a Column

[matteobetti]

Hi, 
As an example, I havea data table like this

Cus1	Marco	2020/09/18	12345
Cus1	Mario	2020/07/01	56789
Cus 2	Giovanni	2020/09/01	11111
Cus 2	Andrea	2020/05/01	34556
Cus 1	Mario	2019/01/01	09876
Cus 3	Luca	2020/06/01	56789

And I need to create a Table that contains only the last created ticket num per Customer

Customer	Reporter	Ticket Num
Cus 1	Marco	12345
Cus 2	Giovanni	11111
Cus 3	Luca	56789

I've created a measure 

LATEST_ISSUE_NUM = MAX(CUS_INC_DATA[CREATED].[Date])

But when I try to create a Matrix I can't put the measur on Rows. 
Any Idea on how to get the table I need? 
Thanks a lot

[amitchandak]

@matteobetti ,

Use this one on a visual table with customer

Last reporter = CALCULATE(lastnonblankvalue(CUS_INC_DATA[CREATED], max(CUS_INC_DATA[Reporter])) ,ALLEXCEPT(CUS_INC_DATA,CUS_INC_DATA[Customer]))

LATEST_ISSUE_NUM = lastnonblankvalue(CUS_INC_DATA[CREATED], max(CUS_INC_DATA[Ticket Num]))

or

LATEST_ISSUE_NUM = CALCULATE(lastnonblankvalue(CUS_INC_DATA[CREATED], max(CUS_INC_DATA[Ticket Num])) ,ALLEXCEPT(CUS_INC_DATA,CUS_INC_DATA[Customer]))

[matteobetti]

Hi @amitchandak , 
thanks for answer. 
I've tried but It does not work for me. 
I Have

Customer	Reporter	Issue Num
Cus 1	xx	xx
Cus 1	xx	xx
Cus 2	xx	xx

I Can't visualize the latest created  by customer

[V-pazhen-msft · Accepted solution]

@matteobetti 
You can create a Calculated Table:

Table 2 = CALCULATETABLE('Table',FILTER('Table',[Created Date]=CALCULATE(MAX('Table'[Created Date]),ALLEXCEPT('Table','Table'[Customer]))))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.