Filter a no-interaction Table

[Irene_B]

Hi all,

I am struggling with this:

I have the field X, which can be "A", "B" or null and a series of measures that for semplicity I will call Measure Y. When Measure Y has values, Measure Z and Field X aren't:

Obs Number	Field X	Measure Y	Measure Z
Obs 1	null	10
Obs 2	null	15
Obs 3	null	20
Obs 4	A		25
Obs 5	B		10

I need to have Field X as a filter and as result a table, that can be:

Field X: A

sum(Measure Y)	sum(Measure Z)
45	25

or

Field X: B

sum(Measure Y)	sum(Measure Z)
45	10

I tried to remove interaction from the filter to the table, and that works with Measure Y, but I get also 35 as a sum of Measure Z. 

Is there a way to keep the filter just on Measure Z?

Thanks a lot!

[Greg_Deckler]

@Irene_B I would keep the interaction and use REMOVEFILTERS in your Measure Y calculation.

[Irene_B]

Hi @Greg_Deckler , thank you for the answer. I fogot to mention the I also have others filters aldready included in the Measure Z calculation (it is a Calculate(sum(measure), filter (etc.))). And also other filters not in the calculation but in the viz, for wich I want to mantain the interation. 

For Measure Y it'the same. 

Thanks again!