Set analysis help comparing 2 fields

[prasadmundewadi]

I have following set analysis which is working as expected for some records and for others it is not working. Can somebody help?

sum({<[Snapshot Quarter]-={$(=Current Snapshot Quarter)}>}[Amount])

I want to sum Amount for all records which have snapshot quarter not equal to current snapshot quarter.

Here 'Snapshot Quarter' is available in a Date dim table. and 'Current Snapshot Quarter' is available on fact table.

Is my set analysis statement correct? (i think it is because it works for many records)

[felipedl · Accepted solution]

Hi Prasad,

try using quotes inside the set analysis

sum({<[Snapshot Quarter]-={"$(=Current Snapshot Quarter)"}>}[Amount])

Felipe.

[prasadmundewadi]

Thank you that worked

[felipedl]

Glad it worked .