I have a problem with the running total for open vs. Total tasks by month.

[marvari]

Hi everyone.

I am learning to work in power BI. And I ran into a problem.

I have a task table.I know the number of open tasks, closed tasks and the total number of tasks.
I summarize them by month.
I calculated the ratio of open tasks to the total number of tasks by month.
But when I want to calculate the running total of open tasks to the total number of tasks, I see incorrect numbers, it seems the division breaks.

Total Task_CC = SUM(Task[Total Task])

Com Total Task = CALCULATE(Task[Total Task_CC],FILTER(ALL('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])))

Sum of Total Completed Task = SUM( Task[Total Completed Task])

Sum of Open Task = SUM(Task[Open Task])

Open vs. Total_CC = DIVIDE(Task[Sum of Open Task], Task[Total Task_CC])

Com Open vs. Total = CALCULATE([Open vs. Total_CC], FILTER(All('Calendar'), 'Calendar'[Date]<= MAX('Calendar'[Date])))

I can't find a solution. I would be grateful for any help.

Thanks community

[v-eqin-msft]

Hi  @marvari ,

If you want to get the running total of Open vs. Total_CC, please try:

Com Open vs. Total = SUMX(FILTER(ALL('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date]) ),[Open vs. Total_CC])

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

[Ashish_Mathur]

Hi,

Share some dat to work with and show your expected result.

[Greg_Deckler]

@marvari I believe you will need a Com Open Task measure that uses the same basic CALCULATE statement as in your Com Total Task measure, otherwise you are only getting the open tasks for the month and comparing it to all tasks.