9 Replies Latest reply: Apr 22, 2015 9:49 AM by Jannet San RSS

    Sum a measure using specific dimensions

      I'm attempting to sum a value based on a list of specific dimension values.


      The expression I am currently using yields results for all the dimensions as is as follows:


      =Sum({$<[BS Date]={"$(=Date(Max([BS Date]),'MM/DD/YYYY'))"}>}[BALANCE])


      I want to include a list of Account Numbers to limit the aggregated [BALANCE] for just those specific numbers.  Something similar to what you would do in SQL (e.g. Where ANUM in ('12345','12364','126346','146345')