isnull
Returns the first non-null argument (or null if both arguments are null). It is recommended to use the sql standard COALESCE function instead.
Syntax
isnull ( expression , expression )Example
isnull ( [Sales (query)].[Sales Fact].[Sales quantity] , 0 )Result
Returns the sales quantity if it's not null, otherwise returns 0.