Forum Discussion

adam_mac's avatar
adam_mac
Icon for Helper I rankHelper I
5 years ago
Solved

DAX IF AND formula between measures

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))

 

 

 

 

 

Help Requested
  • Anonymous's avatar
    Anonymous
    5 years ago

     

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

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