results differ with filter on dimension

[jamielim]

I have a table that sums a measure and presents it against a dimension. I have allowed null dimension to display as well.

e.g.

Dimension	Measure
A	100
B	200
C	300
-	400

figures are correctly presented against each dimension. However, when I apply a filter using any one for the value of the dimension (e.g. select dimension A under filter), the measure goes down to 0 (instead of showing 100) and my table shows null under dimension.

Dimension	Measure
-	0

Any idea what I would likely need to check here?

Is it because I have some measures against null dimension?

Regards,

Jamie

[Lisa_P]

It appears that your selection is excluding all of these dimensions

[balabhaskarqlik]

Can you provide screenshots of Table box Data - Dimension, measure definitions?

What's the version you're using?

[jamielim · Accepted solution]

Found that the variable used in my set analysis for the measures expression was not able to compute successfully when i filter by that dimension as dimension did not affect the variable. Thus, I amended the variable to ignore all filters. then the expression was able to compute even with filter applied.

Problem solved.

[balabhaskarqlik]

That's a good try. Just post the screenshot of Table box, then it'll be helpful for others.