Improve my dax mesure

Hi fbittencourt 

Nb_Projet-à-cloturer =
VAR Datelimit = [Date_jourM-1]
RETURN
CALCULATE(
    DISTINCTCOUNT(FAIT_INDICATEURS[ID projet]),
    FILTER(
        REF_PROJET,
        REF_PROJET[Dernier Statut Projet] IN {"Projet validé","Projet initié"} &&
        REF_PROJET[MEP Date] < Datelimit &&
        [% Avancement conso/AED] > 0.9
    )
)

--------------------------------

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

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!