How to Calculate Running Total Count of ID in %

[Anonymous]

Hello All,

I have a Excel report i have to create it in the POWER BI

Id	Severity	Status	Opendate	Closeddate	Time to Close
26	Medium	Closed	2/11/2021	5/1/2021	80
25	Medium	Open	4/2/2021
17	Low	Closed	5/17/2021	6/29/2021	44
27	Medium	Open	4/13/2021
29	Medium	Open	7/8/2021
16	Low	Closed	5/21/2021	6/29/2021	40
18	Low	Closed	5/24/2021	6/29/2021	37
33	Medium	Resolved	7/12/2021	7/12/2021	1
34	High	Resolved	7/5/2021	8/7/2021	34
42	Medium	Closed	7/15/2021	8/16/2021	33
36	High	Open	6/24/2021
38	Low	Resolved	7/9/2021	7/16/2021	8
39	High	Open	7/6/2021
44	High
45	High
46	High
47	Medium
48	High	Closed
9	Medium	Closed	5/25/2021	6/23/2021	30
22	High	Closed	4/27/2021	5/25/2021	29
30	Medium	Closed	7/8/2021	8/5/2021	29
52	High
53	Medium
54	High	Open	8/11/2021
55	High	Open	8/11/2021
24	High	Closed	4/14/2021	5/5/2021	22
10	Medium	Closed	6/8/2021	6/29/2021	22
58	Low	Open
59	Low	Open
60	Medium	Open
1	High	Closed	10/1/2020
32	High	Open	7/12/2021
40	High	Open	7/18/2021
3	Medium	Closed	6/10/2021
5	High	Closed	6/25/2021
14	Medium	Closed	6/10/2021	6/30/2021	21
12	Medium	Closed	6/8/2021	6/23/2021	16
6	Medium	Open	5/23/2021
35	High	Closed	6/30/2021	7/13/2021	14
7	High	Closed	5/25/2021
11	Low	Closed	5/30/2021	6/11/2021	13
13	Low	Resolved	6/9/2021	6/10/2021	2
8	High	Closed	5/21/2021	5/30/2021	10
49	High	Closed	8/2/2021	8/10/2021	9
50	High	Closed	8/1/2021	8/8/2021	8
51	High	Closed	8/1/2021	8/8/2021	8
56	Medium	Closed	8/1/2021	8/8/2021	8
57	High	Closed	8/19/2021	8/23/2021	5
20	Medium	Open	6/21/2021
21	Low	Open	5/10/2021	6/30/2021	52
23	Low	Open	6/30/2021
28	High	Resolved	7/7/2021	7/8/2021	2
37	Low	Resolved	7/13/2021	7/14/2021	2
41	Medium	Open	7/1/2021
31	Low	Closed	7/6/2021	7/7/2021	2

now i need to show the below line chart with Running Total Count of ID in % in power bi
filters on status {Closed and Resolved} and Closed date is not blank 

[amitchandak]

@Anonymous , Try a measure like

Cumm = CALCULATE(count(Table[Id]),filter(allselected(Table),Table[Closed date] <=max(Table[Closed date]) && not(isblank([Closed date]))))

or join with date table and then try

Cumm = CALCULATE(count(Table[Id]),filter(allselected(Table),Table[date] <=max(Date[date])) ,not(isblank([Closed date])) )

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Anonymous]

Hello Amit,

Thanks for the approach, but it is not working as i was excepting

Power bi reportExcel Report