Set Analysis By pass

[#1]

Hi All,

I have written a set analysis code to get the current month, current year gross amount. The answer is correct, however when I select the filter Dim1 the value changes. Is there a way to keep the value constant even when I click on the Dim1 filter.

Attached the qvw file.

Thanks in Advance.

[MK_QSL]

=sum({<Dim1 =,  Year={$(vCurrentYear)},Month={$(vCurrentMonth)}>}[Gross Amount])

Simply in Set Analysis, whatever you want to bypass...use

Field1 = , Field2 = , etc

[jagan · Accepted solution]

Hi,

Just add Dim1= in set Analysis it excludes the selection of this field in set analysis,

=sum({<Dim1 =,  Year={$(vCurrentYear)},Month={$(vCurrentMonth)}>}[Gross Amount])

Hope this helps you.

Regards,

jagan.

[ashfaq_haseeb]

Hi,

Use below

=sum({<Year={$(vCurrentYear)},Month={$(vCurrentMonth)},Dim1=>}[Gross Amount])

=sum({<Dim1=>}[Gross Amount])

Have a look at attached application too.

Regards

ASHFAQ