1 Reply Latest reply on Jul 25, 2012 1:48 PM by Russell Christopher

    Side by side filtered and not filtered measure with SSAS

    . Danihp

      What is the most easy way to put, in a single workSheet a SSAS mesure filtered and not filtered? (or filtered by different criteria)

       

      Sample:

       

      Lest supose that we have a measure named Sales and 2 dimensions: Regions and Products.

      My goal is to have a table like this:

      |   | 

      RegionSales (filter 1: products X,Y,Z)Sales (filter 2: products X, Y, L)
      A10020
      B12050
      C10140

       

      Notice: At this moment, to accomplish this, I use calculated field with a custom MDX expression. But I will transfer control to end users who are not ready to write this kind of sentences.