Remove nulls from a table

[adecora]

Hi! I need to replace null on a pivot table for zeros. I just been encapsulating the measure like `If(isNull(measure), 0, measure)` and It looks to works fine, but in some cases there is some troubles with some dimensions I share this example where there is still some null values even my measure is 'If(IsNull(Null()), 'null', 'not null`)

Why this is happening? And how I can fix it?

[Nagaraju_KCS]

You can try with this 

Alt(Measure,0)

[BrunPierre]

This returns the measure when it has value, and zero if not.

=Alt(Measure, 0)

[adecora]

The problem is that neither `Alt(measure, 0)` or `If(isNull(measure), 0, measure)` works. It happens on pivot tables when a combination doesn´t exits on the orginal dataset, here a simple example

```

fact:

Load 

Dim1,

    Dim2,

    Month,

    Round(50 + (Rand() * 50), 2) as Value;

Load * Inline [

Dim1, Dim2, Month

    X, a, sept. 

    X, b, sept.

    X, c, sept.    

    Y, a, sept. 

    Y, b, sept.

    Y, c, sept.

    Y, a, oct. 

    Y, b, oct.

    Y, c, oct.

];

```

In this case it happens to october data for dimension X.

It could be achieve with the new pivot table element but user lost functionality to place dimensions on the tables as they want

[SunilChauhan]

Either i am underestimating the problem or understand correct then below solution may help.

I think Simply do

Sum(measure)  in place of 

If(isNull(measure), 0, measure)

 it will shows zero. when we sum  and some column have null .its whos as Zero

Thanks