Implementing an additive formula to funnel table

Hi srahmanfunlab ,

Based on the testing, try using the following DAX formula.

Total User = 
VAR CurrentOrderID = MAX('Funnel Step'[Activity Funnel Reporting Order ID])
VAR MaxOrderID = CALCULATE(
    MAX('Funnel Step'[Activity Funnel Reporting Order ID]),
    ALL('Funnel Step')
)
VAR Steps =
    SUMMARIZE(
        FILTER(
            'Funnel Step',
            'Funnel Step'[Activity Funnel Reporting Order ID] <= CurrentOrderID
        ),
        'Funnel Step'[Activity Funnel Reporting Order ID],
        "UserCount", DISTINCTCOUNT('User Funnel'[User Pseudo ID])
    )
VAR MinUserCount = 
    MINX(
        Steps,
        [UserCount]
    )
RETURN 
    MinUserCount

The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.