Currently displaying the open 90 day pipeline total based on Est Closure date using a relative date filter on the page. This was fine in the beginning as the 90 day pipeline was independent of all other data so a page level filter was no problem. We’re expanding the data being pulled in and the comparisons we want to make. What I need to do now is house the date filtering within my measure to limit it to the next 90 days. I have a date table that spans from 1/1/2016 - 12/31/2018 linked on the Est Close. Current measure is as follows:
Test = VAR MinDate = MIN ( Pipeline[Est Close] ) RETURN IF ( MinDate < TODAY (), BLANK (), CALCULATE ( [Total Open Pipeline $], DATEADD ( Dates[Date], +90, DAY ) ) )
This gives the correct results in a table, however, there is no total. Which means I cannot display the value on a card. What am I missing?