Next Activity Not Assigned

[Almantas32]

Hey Guys, 

I want to count the Leads I entered, that do not have a next activity planned. The problem is that Power Bi only counts the Leads that have an activity assigned. (I guess because the relationship is based on a column in the activity table). But I know I am just missing something. I am ataching the descktop file with an example:

https://drive.google.com/file/d/1fcGqvq7e-3C4Ib51YIVACn1SDs2_MoBT/view?usp=sharing

Would appretiate very much if someone would help me out. 

Almantas 🙂 

[v-yingjl]

Hi @Almantas32 ,

If this is your expected output, you can try this measure to count:

Measure = 
VAR _count =
    COUNT ( 'public mail_activity'[id] )
RETURN
    IF ( _count = 0, 0, _count )

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Almantas32 , You can add +0 to a measure or use this option to have left join after that you can filter on 0 or blank

[Almantas32]

Hello, again, 

and thank you one more time for the help on this question. I have a simple follow up. 

This solution works fine for a table, but I can't display the number with the Card visual. I want to show the count of Leads with no next activities planned in a card visual. 

That means I should insert all the conditions in a measure, right? 

[Almantas32]

Thank you for a simple answer I can use in the future as well 🙂