display zero in the visual card instead of blank

[Huguo90]

I created a measure who calculate a number, but when he don't find the number. But I have BLANK, I'll like to have 0 instead of BLANK. 

here is the measure : 

Statuts_1 = CALCULATE(COUNTROWS(Contact),FILTER(Contact,Contact[Status__c] = "activated"), FILTER(Contact,Contact[DeveloperName] = "Employee"))

Thanks

[Huguo90]

@Mikelytics  It's works. Thanks

[Mikelytics · Accepted solution]

Hi @Huguo90 

Plese try both options:

Statuts_1 = 
CALCULATE(COUNTROWS(Contact),FILTER(Contact,Contact[Status__c] = "activated"), FILTER(Contact,Contact[DeveloperName] = "Employee"))

+ 0

or 

Statuts_1 = 
var var_Calculation =
CALCULATE(COUNTROWS(Contact),FILTER(Contact,Contact[Status__c] = "activated"), FILTER(Contact,Contact[DeveloperName] = "Employee"))

RETURN
IF(ISBLANK(var_Calculation),0,var_Calculation)

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Huguo90]

Hello @Mikelytics , 

I style have the same problem on  statuts_1, can you Help me to resolve that. Thanks,