Isblank or +0 or Blank different behaviour

[Vamshi_PBI]

Hi Team,

Request your help with the below issue, have tried lot of time and couldnt get it.

So my table looks like below.

Campaign Name	Date	Contacted
ABC	13-09-2022	True
BCD	01-09-2022	True
EFG	26-07-2022	False

I have connected this table with a date table and have created a measure for contacted rate which is as below.

CR = "True" records/ total records, and when i drag this measure into the table its working fine but when i add isblank or +0 inorder to hide blank for "False" record with 0 its introducing third record which is not in last 1 month relative date filter.

Please help with this.

Thanks in advance.!

[tamerj1 · Accepted solution]

Hi @Vamshi_PBI 

you try something like 

CR = IF ( NOT ISEMPTY ( 'Table' ), "True" Records/Total Records + 0 )