Forum Discussion

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago
Solved

Make a Measure with a date filter

Hi,   I am trying to make a measure that finds the ACV from a specific date, so that I can then compare that to the ACV from the later weeks. I made this measure as a measure and a calculated colum...
Need Help
  • Gabry's avatar
    Gabry
    1 year ago

    Hello,

    you need to ad all or removefilter.


    Try like this 

    Original ACV = CALCULATE(SUM('DATA'[ACV Weighted Distribution]),'Time'[Time]= "Week Ending 09-15-24", all(time))
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi MichaelaMul 

 

Thanks for the reply from Gabry .

 

And MichaelaMul , after testing, his reply is very effective. If the reply can help you solve your problem, please don't forget to accept the reply as solution so that other users can find solutions faster! Thanks!

 

Here is my testing.

 

My sample:

 

DATA table:

 

Time table:

 

 

Output:

 

Or you can also consider putting ALL in FILTER, the effect is the same.

 

Best Regards,
Yulia Xu