3 Replies Latest reply: Aug 30, 2017 1:59 PM by Felip Drechsler RSS

    Set analysis help comparing 2 fields

    Prasad Mundewadi

      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)