Low performance measures

alsolok this is an optimized version for your code:

% modif = 
DIVIDE (
    CALCULATE (
        [Nb clients],
        KEEPFILTERS(
	        FILTER (
	            ALL('Client'[mail], 'Client'[tel], 'Client'[date_modif] ),
	            'Client'[mail] = 1
	                && 'Client'[tel] = 0
	                && 'Client'[date_modif] <> BLANK ()
	        )
	    ),
        USERELATIONSHIP ( 'Agent'[id_agent], 'Client'[agent_modif] ),
        USERELATIONSHIP ( 'Emplacement'[libelle_empl], 'Client'[modif_CEB] )
    ),
    CALCULATE ( [Nb clients], 'Client'[date_modif] <> BLANK () ),
    0
)

Let me know if that helped.

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI