DAX IF AND formula between measures

adam_mac — Thu, 22 Jul 2021 15:54:58 GMT

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

Re: DAX IF AND formula between measures

Anonymous — Thu, 22 Jul 2021 16:25:49 GMT

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

topic DAX IF AND formula between measures in DAX Commands and Tips

DAX IF AND formula between measures

Re: DAX IF AND formula between measures