Dynamic Summarize/Filter Formula

Hi Kreator

Based on your description, please try the following steps:

1. Create a calculated table as follows.

Date = VALUES('Table'[Date])

2. Create several measures as follow.

MaxDate = 
CALCULATE (
    MAX ( 'Table'[Date] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Journey_ID], 'Table'[Customer_ID] ),
        [Date] >= MIN ( 'Date'[Date] )
            && [Date] <= MAX ( 'Date'[Date] )
    )
)

Measure = IF(SELECTEDVALUE('Table'[Date]) = [MaxDate], 1, 0)

count = COUNTROWS(SUMMARIZE(FILTER('Table', [Date] = [MaxDate]),'Table'[Journey_ID]))

3. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

Is this the result you expect?

Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.