Substraction formula without displaying "0" results

[Anonymous]

Hi,

This might be a stupid question, but I have this formula: 

Unsubmitted =

SUM('report'[Person_Registered]) - SUM('report'[Candidate_Registered])

Both columns have 0 and 1 values, 0 means they haven't registered and 1 means they did.

Of course, Person_Registered is full of 1's as they wouldn't be in the database if they didn't register but Candidate_Registered has 0's and 1's because some of them didn't finish their application form. 

When I add the Measure in a table it shows me the 0's too and I would like it to be blank. Is there something I can add to the formula so the 0's don't display in the table and the rows are left blank?

Filtering the 0's out from the Visual level filters is not an option as it takes out the entire row. 

Thank you very much for your help!

[AlB · Accepted solution]

Hi @Anonymous 

Try this. It will return a blank where the result is zero. You can then select on the visual whether you want to show blanks:

Unsubmitted =
VAR Res_ = SUM('report'[Person_Registered]) - SUM('report'[Candidate_Registered])
RETURN
IF(Res_ <> 0; Res_)

[Anonymous]

Thank you @AlB, it works perfectly!

Just replaced the ";" with a comma 

IF(Res_ <> 0, Res_)

 The full working formula is: 

Unsubmitted =
VAR Res_ = SUM('report'[Person_Registered]) - SUM('report'[Candidate_Registered])
RETURN
IF(Res_ <> 0, Res_)

Have a lovely day!