Forum Discussion

stokidez's avatar
stokidez
Helper III
5 years ago

Running Total Help Needed Please

Hi,   I have a report which looks at the number of projects starting and closing over a period of time. This is simply looking at two different fields, Project Planned Start Date and Planned Contra...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi stokidez ,

 

Check the measure.

Measure = CALCULATE(DISTINCTCOUNT('Table'[Project Title]),FILTER(ALL('Table'),'Table'[Planned Contract Signed Date]>=SELECTEDVALUE('calendar'[date])))

 

Best Regards,

Jay

stokidez's avatar
stokidez
Helper III
5 years ago

Thanks Anonymous 

 

I've added the measure as follows:

Running Total Live Projects = CALCULATE(DISTINCTCOUNT('Procurement Plan'[Contract Title]),FILTER(ALL('Procurement Plan'),'Procurement Plan'[Planned Contract Signed Date]>=SELECTEDVALUE('Date Table'[Date])))
 
However, despite there being projects with a Contract Signed Date, the number does not reduce. Where am I going wrong please?