Excluding a filter from my chart

[ritvik4BI]

Hi All,

I am trying to disable a particular filter i.e. Quarter in my chart but I want that my chart should continue to respond to other filters. I am trying to use set analysis.

The code I am writing is Sum( {<xyz, Quarter=>}Sales) where xyz is an expression which is correct.

But this is not working? The filter from Dimension Quarter is still active and filters my chart which I dont want. What am I doing wrong. Is there any alternative way to achieve this? Do let me know!!

Thanks.

[micheledenardi]

Your expression seems correct.

Can you please post some example data and the full expression you're using?

Alternatively try to use this Sum( {<xyz, Quarter={"*"}>}Sales)

[MayilVahanan]

Hi @ritvik4BI 

where xyz is an expression which is correct.

If xyz is expression, u need to exclude Quarter in that expression too.