topic Re: Remove nulls from a table in Data Quality

Remove nulls from a table

adecora — Thu, 18 Dec 2025 12:45:52 GMT

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?

Re: Remove nulls from a table

Nagaraju_KCS — Thu, 18 Dec 2025 15:09:17 GMT

You can try with this

Alt(Measure,0)

Re: Remove nulls from a table

BrunPierre — Thu, 18 Dec 2025 15:12:39 GMT

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

=Alt(Measure, 0)

Re: Remove nulls from a table

adecora — Thu, 18 Dec 2025 16:34:32 GMT

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