Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
Anonymous
Not applicable
9 years ago

I initally solved this issue, and now Ive made it far more complicated.

 

I essentially have a table with two dates in it: StartDate and ActualStart. Every row has a StartDate but the ActualStart can be blank so I adapted the formula to ignore blanks. 

 

My adaptatons work perfectly if I put them in indiviual graphs but I need to overlay them on on graph. Using either date as the X axis breaks the other count (Because I think it ignores dates and just counts values)

 

Attached are the Measures and some images of the current broken graph. 

 

As you see in the data the line Cumulative Tasks Actually Started shouldnt stay flat? But tasks planned to start is perfect. If i change the X axis to ActualStart then it reverses with Actually Started working but Start Date broken.

 

Cumulative Tasks Planned To Start = CALCULATE (COUNTROWS('Asta Outputs - Task'), FILTER (ALLSELECTED('Asta Outputs - Task'), 'Asta Outputs - Task'[StartDate] <= MAX('Asta Outputs - Task'[StartDate])))
Cumulative Tasks Actually Started = CALCULATE (COUNTROWS('Asta Outputs - Task'), FILTER (ALLSELECTED('Asta Outputs - Task'), 'Asta Outputs - Task'[ActualStart] <= MAX('Asta Outputs - Task'[ActualStart])), NOT(ISBLANK('Asta Outputs - Task'[ActualStart])))

Thanks,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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