How to make the number (with set analysis) don't change with filters

[wanyunyang]

Hi guys,

I have a formula like this:

sum({<Year={'2020'},Month={'July'}>} Sales). 

Currently, if I select Year = 2020 and Month= August, the result turns 0. How can I make the result fixed and don't change with the filters?

Thank you in advance!

[Kushal_Chawda]

@wanyunyang 

sum({<Year,Month,Year={'2020'},Month={'July'}>} Sales). 

[Vegar]

Your selections should not give you a zero result. Are you sure that you are not making any other calendar dimension selections, like in a Year-month field or similar?

If you are making such selections then you will need to cancel them out in your set expression like this. 

sum({<[Year-month], Year={'2020'},Month={'July'}>} Sales)

Good luck solving your issue.