Ignoring a dimension based on user selection

[#1]

Hello:

I have a chart which I want the users selected date(s) to be ignored as I want to present all the dollar values totalled by year. I've attached a sample file.

My problem is that when calculating "Equity" the dollar value is correct for the user selected year but out for all the other years, even though my expression is coded to ignore the date selections. I can't figure out why the dollar value is only correct for the selected year?

Thx,

[whiteline · Accepted solution]

Hi.

I've made some investiogations. The problem is with your if() expression.

You should use something like this:

if (Only({<[Fiscal Year]=,Month=, Quarter=>} Field) = 'Equity',...

otherwise it falls to else for every year excluded by selection.

[#3]

Thanks so much, this board is awesome and your help is much appreciated!