Calculating total number of opportunities from the start of the year to the current date

[Khurramalidar]

I am using the following formula to calculate the total number of opportunities from the start of the year to the current date but I am getting a value 333 which is the total number of opportunities in that entire year. I just want to see how many opportunites are there from example 1st Jan 2024 to Current date of 2024.

Running Total = TOTALYTD(COUNT('opportunity'[Opportunity]), 'opportunity'[Est. close date])

what changes do I need to make to my DAX query to get the running total of opportunities till 4th of April which is the current date. 

Please help

[Ritaf1983]

Hi @Khurramalidar 
Modify the formula to 

Running Total = calculate(TOTALYTD(COUNT('opportunity'[Opportunity]), 'opportunity'[Est. close date]),opportunity'[Est. close date]<=today()
I prepared an example with my data it will look like this:

pbix is attached

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

[Shreeram04 · Accepted solution]

Hi @Khurramalidar ,

Try below measure

Running Total =
TOTALYTD(
COUNT('opportunity'[Opportunity]),
'opportunity'[Est. close date],
FILTER('opportunity', 'opportunity'[Est. close date] <= TODAY())
)

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

Thanks,

Hari R