Total of Tickets Resolved by Day

[ceaton]

Hello,

I am trying to create a measure that will show the total number of Ticket IDs per Resolved Date.  I looked at some past answers, but they all involved me joining a Calendar table and I lost my date hierarchies in my table.  I really need to keep those date heirarchies.

Ticket ID	Created Date	Resolved Date	Create to Respond (Hours)	Create to Resolve (Hours)
21467272	6/12/2024	7/18/2024	0.29	213.38
21459131	6/10/2024	7/18/2024	8.07	220.11
21426227	5/30/2024	7/16/2024	32.1	262.48
21486754	6/18/2024	7/15/2024	113.92	152.65
21499099	6/24/2024	7/15/2024	16.71	126.89
21480103	6/17/2024	7/15/2024	0.46	164.73
21481940	6/17/2024	7/15/2024	5.36	159.37
21468448	6/12/2024	7/15/2024	32.56	185.41
21482419	6/17/2024	7/15/2024	4.7	158.02
21480193	6/17/2024	7/15/2024	10.12	160.97
21486958	6/18/2024	7/15/2024	0.36	147.13
21480331	6/17/2024	7/12/2024	141.48	154.71
21439679	6/4/2024	7/10/2024	4.25	213.96
21515428	6/27/2024	7/10/2024	66.29	66.29
21517799	6/28/2024	7/10/2024	44.5	62.45
21518191	6/28/2024	7/10/2024	6.98	59.4
21503036	6/24/2024	7/9/2024	86.68	86.84
21514453	6/27/2024	7/9/2024	1.63	64.82

Here's the measure I attempted to use, but it keeps giving me errors:

Measure = CALCULATE(COUNT(Sheet1[Ticket],FILTER(all(Sheet1),Sheet1[Resolved Date]=SELECTEDVALUE(Sheet1[Resolved Date]&&Sheet1=SELECTEDVALUE(Sheet1[Ticket]))))

Any help you can give a newbie would be very appreciated!

[rajendraongole1]

Hi @ceaton - create below measure to ge the total number of Ticket IDs per Resolved Date

CountTt =

CALCULATE(

    COUNT(TTTC[Ticket ID]),

    FILTER(

        ALL(TTTC),

        TTTC[Resolved Date] = SELECTEDVALUE(TTTC[Resolved Date])

    )

)

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[ceaton]

Thank you, I tried:

CountTt =

CALCULATE(

    COUNT(Sheet1[Ticket]),

    FILTER(

        ALL(Sheet1),

        Sheet1[Resolved Date] = SELECTEDVALUE(Sheet1[Resolved Date])

    )

)

But I should have tickets for every single day, instead I'm seeing results like this:

[Anonymous]

Hi @ceaton 

Please try this:

Create a new calendar table:

Table =
	CALENDAR(
		MIN('Sheet1'[Resolved Date]),
		MAX('Sheet1'[Resolved Date])
	)

Then add a measure:

MEASURE =
VAR _currentDate =
    MAX ( 'Table'[Date] )
VAR _Outcome =
    CALCULATE (
        COUNT ( 'Sheet1'[Ticket ID] ),
        FILTER ( ALLSELECTED ( Sheet1 ), 'Sheet1'[Resolved Date] = _currentDate )
    )
RETURN
    IF ( _Outcome = 0, 0, _Outcome )

The result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ceaton]

Hello,

OK, I tried what you provided and all the rows are zeros:

Please let me know what I am doing incorrectly!