Cumulative Max Days

@pankajj

I haven't exactly got what you're trying to do, but this measure will give you what you need

Cumulative Max Days = 

CALCULATE(
    COUNT(Dates[Date]),
    FILTER(
        ALLSELECTED(Dates),
        Dates[Date] < MAX(Dates[Date] )
    )
)

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin

@Fowmy

Thanks a ton for your kind help. It worked perfectly with the sample file i shared.

In the meantime i created following measures to get the desired result in my existing data.

Open =
Was
(dates[Date])
RETURN
calculate(
CALCULATE(count(SN[ID])+0,
SN,
SN[Created]<=d
),
crossfilter(SN[Created],Dates[Date],None)
)

OLDEST_Open_Date =
Was
d - MAX (Dates[Date])
RETURN
CALCULATE(
FORMAT(CALCULATE(MIN(SN[Created]),
SN,
SN[Created]<=d),
"Short Date"
),
CROSSFILTER(SN[Created],Dates[Date],None)
)

Cumulative_Max_Days =
Was
d - Max (Dates[Date])
RETURN
CALCULATE(if([Open]>0,DATEDIFF(SN[OLDEST_Open_Date],d,Day),0))