how to get max(date) as a dimension

[#1]

I have table like this

how to plot a chart to get dimension is like max(date) or previous day and I have created measure like how many created and how many submitted

Thanks

Ticket_no	Date	Status
1	1/27/2014	Created
1	1/28/2014	Modify
1	1/29/2014	SUBMIT
1	2/2/2014	Closed
2	1/27/2014	Created
2	1/28/2014	Modify
2	1/29/2014	SUBMIT
3	2/2/2014	Created
3	2/2/2014	Modify
3	8/8/2014	SUBMIT
4	3/1/2014	Created
4	3/1/2014	Modify
5	8/8/2014	Created
5	8/8/2014	Modify
5	10/8/2014	SUBMIT
6	8/9/2014	Created
6	8/9/2014	Modify
6	10/8/2014	SUBMIT
6	11/11/2014	closed

[#2]

Date=Max(dates1) is saying invalid dimension

I have tried Date=today()-1 for previous day but it is not showing the tickets on that day instead showing full count..

I have a master calendar in the data model ... the join is b/w this table->Date and master calendar ->Date