Forum Discussion

pablopablo's avatar
pablopablo
Frequent Visitor
5 years ago
Solved

Help with running cumulative count

Hi,   I have the following code which correctly gives me a running total based on a week number of total jobs opened per week. However, i need to amend so it does not count those jobs which have al...
General Comment
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi pablopablo ,

     

    Try this.

    Measure = 
VAR x = 
CALCULATE(
    COUNT(Sheet10[Job No]),
    FILTER(
       Sheet10,
        [Week Opened] <= MAX('Calendar'[Week]) && [Week Closed] > MAX('Calendar'[Week])
    )
)
RETURN
x

     

    Best regards,
    Lionel Chen

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

     

pablopablo's avatar
pablopablo
Frequent Visitor
5 years ago

Hi,

 

I used your article and have the following code:

 

Weekly Cummulative = CALCULATE(COUNTx(FILTER('Live_Roles_Feed',Live_Roles_Feed[Date opened]<=max('Calendar_New'[Date]) && (ISBLANK('Live_Roles_Feed'[Date job closed]) || 'Live_Roles_Feed'[Date job closed]>max('Calendar_New'[Date]))),('Live_Roles_Feed'[Job no.] )),CROSSFILTER(Live_Roles_Feed[Date opened],'Calendar_New'[Date],None))

 

 

However, it displays like this. I have even created a calendar table using your guide and linked accordingly