Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My dashboard showed "(BLANK)" as the value in a card visualization - when I really wanted to see "0".
Is there a best practice to deal with this, or a simple way to adjust this?
Here is my current solution.
Note: This does not seem to be a data type issue. The card is calling on a measure that is calculated as follows:
Total CRs that have moved to P = CALCULATE([Total CRs - for calculations], 'Release_CRs_Systems (CRs Moved Only)'[Friendly System Name] = "P")
2) The data type for "Total CRs - for caculations" is "Whole Number"
3) [Total CRs - for calculations] is a SUM function - type "Whole Number"
CURRENT SOLUTION:
Create a new measure that evaluates [Total CRs that have moved to P] and uses IF(ISBLANK)
DISPLAY CALC FOR CR IN P =
IF( ISBLANK('Release_CRs_Systems (CRs Moved Only)'[Total CRs that have moved to P])
, 0
, ( 'Release_CRs_Systems (CRs Moved Only)'[Total CRs that have moved to P]))
*****
Can anyone provide a more elegant solution?
Add a New Measure.
Assign your expression and " + 0 " at the end.
Ex:
NewMeasure = Sum(Table_Name[Field_Name]) + 0
Hi Misakkk,
Check this out...
Measure= IF(CALCULATE(count(column),column ="condition") >0,CALCULATE(count(column),column ="condition"),0)
+0 works very well for me!!
Matt
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |