Target for task Completion everyday

[Anonymous]

Hello I have a Tasks Table 

IDStateDate

1	1	27/4/2022
2	1	27/4/2022
3	1	27/4/2022
4	1	27/4/2022
5	1	27/4/2022
6	1	27/4/2022
7	1	27/4/2022
8	2
9	2
10	2
11	2
12	1	26/4/2022
13	1	25/4/2022
14	1	25/4/2022
15	1	25/4/2022
16	2
17	2
18	2
19	1	24/4/2022
20	1	24/4/2022

since Completion State 1 mean completed

but 2 is Incomplete..

I have a dax for find cumulative Completion over time ..

completed %:=calculate(counta(ID),[State] = 1) /counta(ID)*100

-------------------------------

Cumulative Total:=
CALCULATE([completed %],
FILTER(ALL('tasks'),
tasks[complete_date] <= MAX(tasks[complete_date])
)
)

now I want a cummulative target for every day to be plot side by side with cumulative total..

(lets say that those tasks should be done in 10 days)

which (total tasks)/10 = 20/10 =2 every day... to calculate target % = 2/20 = 10% every day--> so the graph will show in fisrt date

10% then 20% then 30 % and so on until the max date

any help to create dax equation for target

[amitchandak]

@Anonymous , Try measures like

completed %:= Divide(calculate(counta(tasks[ID]),Filter(tasks, tasks[State] = 1)) ,counta(tasks[ID]))

Cumulative Total:=
CALCULATE([completed %],
FILTER(ALL('tasks'),
tasks[complete_date] <= MAX(tasks[complete_date] && not(isblank(tasks[complete_date])) )
)
)

But better use date table join with date  and use date from date table in visual

Cumulative Total:=
CALCULATE([completed %],
FILTER(ALL('Date'),
Date[Date] <= MAX(Date[Date])) , not(isblank(tasks[complete_date])) )

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

[Anonymous]

thank you that was helpful to make the cumulative total more accurate...

but how about the target...

maybe if you didnt get my point ... target should be all tasks devided by total days to be needed to be done with... so if I have 20 tasks regardless to complete status and I want them to be finished in 10 days that means each day should have 2 tasks done... those 2 tasks percent from the total which is 20 tasks is 10%

so the graph should draw 10 then 20 then 30 then 40 and so on for each day..

can you help me with that

[v-shex-msft]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng