cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## display zero in the visual card instead of blank

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
1 ACCEPTED SOLUTION
Resident Rockstar

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!

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

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
3 REPLIES 3
Helper I

@Mikelytics  It's works. Thanks

Resident Rockstar

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!

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

------------------------------------------------------------------
Visit my blog datenhungrig which I recently started with content about business intelligence and Power BI in German and English or follow me on LinkedIn!
Helper I

Hello @Mikelytics ,

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.