Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
Solved! Go to 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.
-----------------------------------------------------
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.
-----------------------------------------------------
Hello @Mikelytics ,
I style have the same problem on statuts_1, can you Help me to resolve that. Thanks,
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |