DAX IF AND formula between measures

[adam_mac]

Hi, my skills at DAX if statements are proving atrocious so any help is much appreciated. 

I am trying to create a measure that simply calculates if the count of referral leads is > 0 and the count of activities relating to that referral is blank, to then mark true or false (the idea being to eventually highlight leads that have had no activity).

The formula i have written seems to kind of work but it is still marking a zero against accounts with no activities against them. Any idea what ive done wrong?

No Activity Check = 

SUMX(

 C4C_Referral_Leads,

 IF(

 DISTINCTCOUNT( C4C_Referral_Leads[Lead ID] ) > 0 &&

 DISTINCTCOUNT( MergedActivities[Activity ID] ) = BLANK(),

 1,0))

[Anonymous · Accepted solution]

[No Activity Check] = 
if(
	NOT( ISEMPTY( C4C_Referral_leads) )
	&&
	ISEMPTY( MergedActivities ),
	1
)