Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |