Forum Discussion
Cumulative count for graph
Hello, I am trying to produce a cumulative count for my data, I've attempted to use a method that I see frequently in the forums but cannot seem to get it to work. See screen shot attached wi...
Hi Anonymous,
I think the issue may related to the NOT(ISBLANK('Asta Outputs - Task'[ActualStart])), perhaps you can try to move the blank filter into filter function.
Cumulative Tasks Actually Started = CALCULATE (COUNTROWS('Asta Outputs - Task'), FILTER (ALLSELECTED('Asta Outputs - Task'), 'Asta Outputs - Task'[ActualStart] <= MAX('Asta Outputs - Task'[ActualStart])&&[ActualStart]<>BLANK()))Regards,
Xiaoxin Sheng
Anonymous i think the issue here is that you need to create a date table, have you done that and then link the date to the date table