Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Monthly in progress ticket

Hello,   I have  a measure that counts the monthly in-progress tickets as below :  Inprogress=     CALCULATE (           COUNTA(BugRun[created]);           FILTER( ALLSELECTED(BugRun);        ...
Tips and Tricks
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

No sample data so I'm not sure if code below can achieve your requirement:

Inprogress =
CALCULATE (
    COUNTA ( BugRun[created] );
    FILTER (
        ALLSELECTED ( BugRun );
        (
            BugRun[resolutiondate] = BLANK ()
                || BugRun[resolutiondate]
                    > CALCULATE ( MAX ( Calendrier[DateSlicer] ); ALLSELECTED ( Calendrier ) )
        )
            && BugRun[createddate]
                <= CALCULATE ( MAX ( Calendrier[DateSlicer] ); ALLSELECTED ( Calendrier ) )
    )
)

Community Support Team _ Jimmy Tao

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-yuta-msft ,

 

The data is simple: 

 

createdresolutiondate
03/10/2019 13:08:51null
24/09/2019 16:37:1810/10/2019 15:42:18
23/09/2019 15:04:10null
20/09/2019 10:59:4225/09/2019 16:48:58
20/09/2019 15:36:5308/10/2019 18:21:26
13/09/2019 11:32:5420/09/2019 15:20:38
10/09/2019 11:13:4208/10/2019 15:25:20
10/05/2017 10:01:2219/10/2018 17:34:33
24/09/2018 12:17:2416/01/2019 18:31:04
27/03/2018 17:17:5026/03/2019 18:00:04
17/05/2018 19:10:4003/06/2019 09:41:22
13/09/2018 11:51:4316/01/2019 18:30:56
08/10/2018 11:42:1106/02/2019 12:21:55
08/10/2019 15:20:03null
08/10/2019 08:34:12null
30/09/2019 15:26:1107/10/2019 17:57:11
27/09/2019 09:50:46null
11/09/2019 09:16:0811/10/2019 09:32:46
16/09/2019 11:14:48null
12/07/2019 10:21:56null
17/09/2018 14:23:3809/11/2018 14:45:05
30/03/2018 11:51:3308/03/2019 09:53:41
05/01/2018 15:53:1923/10/2018 08:39:21
26/03/2018 18:00:4204/03/2019 17:32:54
08/10/2019 14:46:50null
07/10/2019 09:46:58null
01/10/2019 11:31:4701/10/2019 18:56:07
25/09/2019 16:36:14null
13/09/2019 11:32:23null
13/09/2019 19:05:49null
09/09/2019 09:30:0108/10/2019 10:40:56
17/01/2018 20:12:4123/10/2018 12:04:04
12/06/2018 11:42:0920/11/2018 16:15:22
13/03/2018 18:40:0116/01/2019 18:31:12
12/10/2018 10:54:1405/11/2018 18:09:00
04/10/2019 11:58:14null
25/09/2019 17:39:51null
12/09/2019 14:28:0719/09/2019 11:52:24
06/09/2019 09:30:4212/09/2019 11:38:40
16/08/2018 16:36:5109/11/2018 15:49:27
17/05/2018 11:37:2016/01/2019 18:30:55

 

I tried your measure, but it gives me the same amount of inprogress tickets for all time.

Trang