Pivot table not showing empty measures

[Morgoz]

Hello,

I have created a pivot table to show Data Quality's total errors for each source input channel.

The thing is that not all Data Qualities throw errors for all the channels, so the result is that not all the Data Qualities have all the channels shown in the table, and I need all DQs showing all channels, also if they have no errors.

I have configured the pivot table like this:

Dimensions: DQ_TITLE and CHANNEL
Measure: Count({<EXEC_DATE_SQL={"$(exec_date)"}>} ID_DQ_FACTS) + Sum({1<CHANNEL={"*"}>} 0)

I don't know if the "SUM" is useful at all...
ID_DQ_FACTS is a unique ID for each DQ error of all DQs.

At Dimensions I have also check "Include null values"

Here is an example of the result:

As you can see, not all DQs (at left) have the same number of channels, because the channels that have no errors are not showing.

Thanks!

[Morgoz]

Hello again,

I don't know why there are no answers... Is the question not clear? Is there no way to solve this? Am I asking something weird?

I think that the reason why not all the Channels are showing for all the Data Qualities is because for those channels in those Data Qualities there is no data at all, no errors have ever happend for Data Quality 2 and Channel "Broker", for example.

I have tried this solutions without success:

If(isnull(Count({<EXEC_DATE_SQL={"$(fecha_ejecucion)"},ACCOUNT_TYPE_ID={'C'}>} ID_DQ_FACTS) + Sum({<CANAL={"*"}>} 0)),0,Count({<EXEC_DATE_SQL={"$(fecha_ejecucion)"},ACCOUNT_TYPE_ID={'C'}>} ID_DQ_FACTS) + Sum({<CANAL={"*"}>} 0)))

Alt((Count({<EXEC_DATE_SQL={"$(fecha_ejecucion)"},ACCOUNT_TYPE_ID={'C'}>} ID_DQ_FACTS) + Sum({<CANAL={"*"}>} 0))*1,0)

If(Len(Trim(Count({<EXEC_DATE_SQL={"$(fecha_ejecucion)"},ACCOUNT_TYPE_ID={'C'}>} ID_DQ_FACTS) + Sum({<CANAL={"*"}>} 0))) > 0, Count({<EXEC_DATE_SQL={"$(fecha_ejecucion)"},ACCOUNT_TYPE_ID={'C'}>} ID_DQ_FACTS) + Sum({<CANAL={"*"}>} 0), 0)

Thanks.