in data view in visual view numbers difference

Hi chaitanya1 

 Your terminated customers users this

FILTER (
    ALL ( 'V1+V2+Terminations CitiesOrders' ),
    'V1+V2+Terminations CitiesOrders'[endDate] <= MonthEnd
)

This removes all filters from the table and applies a custom filter based on endDate. So it behaves consistently across visuals and the Data view

Active customers uses

FILTER (
    ALL ( 'V1+V2+Terminations CitiesOrders' ),
    'V1+V2+Terminations CitiesOrders'[startDate] <= MonthEnd
)

This also removes filters, but only considers startDate. If your data model or visuals apply filters on endDate, New OrderStatus, or other fields, they might interfere unless explicitly removed.

Also, if your visual has slicers or filters (e.g., city, product, etc.), they do apply unless removed with ALLSELECTED, REMOVEFILTERS, or ALL.

Use this modified DAX for Active users

Active Customers EOM =
VAR MonthEnd = EOMONTH(MAX('DimDate'[Date]), 0)
VAR ActiveCount =
    CALCULATE(
        DISTINCTCOUNT('V1+V2+Terminations CitiesOrders'[Service Ref]),
        'V1+V2+Terminations CitiesOrders'[New OrderStatus] = "Active",
        FILTER(
            ALL('V1+V2+Terminations CitiesOrders'),
            'V1+V2+Terminations CitiesOrders'[startDate] <= MonthEnd &&
            (
                ISBLANK('V1+V2+Terminations CitiesOrders'[endDate]) ||
                'V1+V2+Terminations CitiesOrders'[endDate] > MonthEnd
            )
        )
    )
VAR LatestMonth =
    EOMONTH(
        MAXX(ALL('V1+V2+Terminations CitiesOrders'), 'V1+V2+Terminations CitiesOrders'[startDate]),
        0
    )
RETURN
IF(MonthEnd <= LatestMonth, ActiveCount, BLANK())

I hope this helps, please give kudos and mark as solved if it does, thanks!