Calculating Ticket Close Ratio

[maxse]

I'm running into an issue since the quick measure does not allow for relative date formatting. I'm trying to return the similar functionality of the filter date pane of 'is in this - day'. Which will provide me with a filtered measure of all tickets entered today. I will then duplicate this so I can create another of tickets closed today, etc.

The current DAX code I have is using the quick measure so I can only pick one date. Please let me know what to change so the result will be 'is in this - day'.

QuickMeasureFilter = 
CALCULATE(
	COUNTA('v_rpt_Service_Summary'[TicketNbr]),
	'v_rpt_Service_Summary'[Date_Entered_UTC]
		IN { DATE(2015, 4, 23) }
)

[FreemanZ]

hi @maxse 

supposing you have a column named data[date], then try to change your quick measure to:

QuickMeasureFilter =
CALCULATE(
    COUNTA('v_rpt_Service_Summary'[TicketNbr]),
    'v_rpt_Service_Summary'[Date_Entered_UTC]
        IN { VALUES(data[date]) }
)

[maxse]

I'm not sure how that is going to return the results for today?

[FreemanZ]

hi @maxse 

As you have the data, just try it. 

p.s. If you need further input, consider @me in the reply.