Forum Discussion
MichaelaMul
Helper III
Helper IIIMake 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...
Hello,
you need to ad all or removefilter.
Try like thisOriginal ACV = CALCULATE(SUM('DATA'[ACV Weighted Distribution]),'Time'[Time]= "Week Ending 09-15-24", all(time))
Gabry
Super User
Super UserHello,
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))