How to ignore selection in filter

[daria]

Hi All,

I have source data like this:

SourceData:
Load * inline [SetName, Date, Type, Value
'A',	30/10/2020,	1,	1
'A',	26/10/2020,	1,	2
'B',	30/10/2020,	1,	3
'B',	26/10/2020,	1,	Null
'C',	30/10/2020,	1,	2
'C',	25/10/2020,	1,	3
'D',	25/10/2020,	1,	4
'A',	30/10/2020,	2,	4
'A',	26/10/2020,	2,	3
'B',	30/10/2020,	2,	Null
'B',	26/10/2020,	2,	Null
'C',	30/10/2020,	2,	1
'C',	25/10/2020,	2,	5
'D',	25/10/2020,	2,	2
];

I use pivot table to display Sum of Values by Type for each SetName :

Also I have a filter by Date. But I want to see ALL values for SetName regardless of the selected Date in the filter. I just want to see static 'A, B, C, D,' in SetName and different measure values or 'Null' if there are no values for specific date.

Is it possible? Does anyone know how to do this?

[rubenmarin]

Hi @daria , try setting as expression Sum(Value)+Sum({1}0)