Count measure is removing the records that don't match set analysis criteria

[Joseph_Kipling]

Hi all,

I have a few data sources joined together and I have produced a table with all the relevant dimensions I need. I have also added a calculated measure that only counts certain records based on the set analysis criteria but the calculation means the records that don't match the criteria have now been omitted from the table and the only records left show a value of '1' in the calculated field with the total at the top.

Is there anyway for the 'Count'({})' measure to still show the omitted records as a value of '0'? I have made work around by including another calculated field that counts all records... but this seem silly and counter intuitive to me?

Thanks, 

Joe

[Joseph_Kipling]

OK I will create a mock up and send it over.

[sunny_talwar]

Can you try this and see if this work

=count({<[Leads.Lead Number]={"=if(([Leads.LeadType]='Retail' and [Leads.LeadCode]=[Leaflet Design]) or ([Leads.LeadType]='Retail' and [Leads.IntervalWeek]<=4 and [Leads.ResponseChannel]='Web') or ([Leads.LeadType]='Retail' and [Leads.ResponseChannel]='Generic'),[Leads.Lead Number])"}>} distinct [Leads.LeadID]&[Leads.First]&[Leads.Last])

+

Sum({1} 0)