9 Replies Latest reply on Sep 26, 2018 4:21 AM by Mahfooj Khan

    Calculated field with an "WHERE" clause possible?

    Marko Radenkovic

      Hi there,

       

      Im trying to display a measure which is filtered by a dimension.

       

      I want to create a calculated field where actually the measure is already filtered within the field.

       

      So basically, in SQL it would be very easy:

       

      Select Sales

      From Orders

      Where Sales = "x";

       

      I tried IF statements but could not come to any solution.

       

      (Can´t share the workbook unfortunately due as sensible information).

       

      Thanks upfront,

      Marko