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,