Date filter in measure DAX

[Anonymous]

Hello everyone

I want to make a measurement, calculate the number of subscriptions filtered by a date, but I can't

How to add a date filter in the measure?

I thank you in advance

Nuber_Subscriptions=

CALCULATE(

COUNT('DWH_D_Abonnés'[id_user_account]),

DWH_F_Souscription[date_subscription]<= 01/10/2022

)

[PaulDBrown]

Try:

Nuber_Subscriptions =
CALCULATE (
    COUNT ( 'DWH_D_Abonnés'[id_user_account] ),
    FILTER (
        DWH_F_Souscription,
        DWH_F_Souscription[date_subscription] <= DATE ( 2022, 10, 1 )
    )
)

[Anonymous · Accepted solution]

Thank you very much! it works