There is two better ways to achieve your aim and without creating new measures:
- Use format_string property in the measure properties.
The FormatString property accepts four arguments separated by a semicolon (;). The first argument is how positive value should be formatted, the second is how negative values should be formatted, the third argument is how 0 values should be formatted, and the fourth argument is how NULL should be formatted. The fourth argument is the one we are interested in! Here is an example of how I am formatting the Reseller Sales Amount: “#,##0.00;-#,##0.00;;0”.
use scoope statement in calculations tab :
SCOPE([Measures].[col_]); THIS=IIF(ISEMPTY([Measures].[col_]),0,[Measures].[col_]); END SCOPE;
CLICK HERE to find out more related problems solutions.