How to create percentage trendline ?

[Tim_H]

Hi,

I want to create a percentage trendline for all closed tickets in time

I already created two tables in XLS to count tickets per day

DaysTicket #

0	3
3	1
7	1
9	1
11	1
16	1
17	1
21	1
24	1
29	1
76	1
172	1
280	1

	Input Pivot
Days	Number of tickets	Solved %	Target KPI %
0	3	20%	92%
1	0	20%	92%
2	0	20%	92%
3	1	27%	92%
4	0	27%	92%
5	0	27%	92%
6	0	27%	92%
7	1	33%	92%
8	0	33%	92%
9	1	40%	92%
10	0	40%	92%
11	1	47%	92%
12	0	47%	92%
13	0	47%	92%
14	0	47%	92%
15	0	47%	92%
16	1	53%	92%
17	1	60%	92%
18	0	60%	92%
19	0	60%	92%
20	0	60%	92%
21	1	67%	92%
22	0	67%	92%
23	0	67%	92%
24	1	73%	92%
25	0	73%	92%

in the end I want to become something as below

How can I calculate the solved % using dax ?

Thanks

Tim H

[Jihwan_Kim · Accepted solution]

Hi, @Tim_H 

Please correct me if I wrongly understood.

please check the below picture whether it is what you need. 

total quantity cumulate =

CALCULATE( [total quantity], FILTER(

ALLSELECTED(Days_Table), Days_Table[Days] <= MAX( Days_Table[Days])))

PBIX file link is down below.

https://www.dropbox.com/s/sjnbhyqbqg8d4yo/TimH%202021%200324.pbix?dl=0 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

[Tim_H]

not exactly how I dit it..but you really helped in finding the solution. 

[Tim_H]

This is in the way I want it...only I have a calculation before I came to the tables shown above.

for example: I use below calculation to get tickets per day

_Final_sol_time tickets age grouping = COUNTROWS(FILTER(overview, overview[Case Milestone_Final Sol Actual Elapsed Time]>=VALUES('Hours Grouping'[min])&& overview[Case Milestone_Final Sol Actual Elapsed Time]<=VALUES('Hours Grouping'[max])))

This gives me below

blue flat line is KPI

it is on this graph I want to add the cumulative percentage.

kr

Tim H

[Jihwan_Kim]

Hi, @Tim_H 

Thank you for your information.

Is it OK with you to share your sample data?

It helps me a lot to look into it with a clear idea.

Thank you very much.

[Tim_H]

I have to see how to create a sample from the whole pibx..current PIBX has +400k lines and +200 columns wit some restricted data (GDPR).