Showing a Zero if Calculate/Countrow has no record for user

[gazzo1967]

HI All
I have an employee table relataionship modelled to a activity table by email.

I use the following to return my count 

GAZROLE_BA_TOTALCount1 = CALCULATE(

    COUNTROWS(ROLE_COUNT_IND),SEARCH("BA Wearer",ROLE_COUNT_IND[Role_BA],,0)&& SEARCH("Required standard achieved",ROLE_COUNT_IND[answer],,0))

Outcome

Role_ID	UserName	Location	BA Role	email	GAZROLE_BA_TOTALCount1
1	Mike.user	Town	BA Wearer	blah1	1
2	Dave.user	City	BA Wearer	blah2	1
3	Joe.user	City	BA Wearer	blah3	2
8	Paul.user	Town	BA Wearer	blah5	1

This works fine 

But here is what I would like to do is show the users with a zero based upon my employee table, if they do not make the criteria for the count  not filter the visual to those who have only rows

My table example data

ROLE_COUNT_IND

Role_ID	UserName	Location	BA_ Role	email	answer	activity_date
1	Mike.user	Town	BA Wearer	blah1	Required Standard Achieved	01/01/2023
2	Dave.user	City	BA Wearer	blah2	Required Standard Achieved	03/02/2023
2	Dave.user	City	BA Wearer	blah2	Not Assessed	04/03/2023
2	Dave.user	City	BA Wearer	blah2	Required Standard Achieved	21/06/2021
3	Joe.user	City	BA Wearer	blah3	Required Standard Achieved	27/12/2021
6	Andy.user	Town	BA Wearer	blah4	Required Standard Achieved	12/08/2021
3	Joe.user	City	BA Wearer	blah2	Required Standard Achieved	20/07/2021
8	Paul.user	Town	BA Wearer	blah5	Required Standard Achieved	16/03/2023

Employee Data Table

Role_ID	UserName	Location	email
1	Mike.user	Town	blah1
2	Dave.user	City	blah2
3	Joe.user	City	blah3
6	Andy.user	Town	blah4
8	Paul.user	Town	blah5
10	Pete.user	Town	blah6
11	Will.user	City	blah7

If i use my Employee Data table values first

Role_ID

UserName

Location

email

 then add the count 

So the outcome becomes

Role_ID	UserName	Location	email	GAZTESTBA1
1	Mike.user	Town	blah1	1
2	Dave.user	City	blah2	1
3	Joe.user	City	blah3	2
6	Andy.user	Town	blah4	0
8	Paul.user	Town	blah5	1
10	Pete.user	Town	blah6	0
11	Will.user	City	blah7	0

Thanks for any help in advance
Gary

[Greg_Deckler · Accepted solution]

@gazzo1967 Try adding +0 to your measure.

[gazzo1967]

@Greg_Deckler 
You know what!!
I'm so annoyed with myself because I did that but put the  '+0' in the wrong place!!😡
I put it before the last bracket rather than after..
everydays a school day lol
Thanks Greg 🙂