4 Replies Latest reply: May 12, 2017 4:33 AM by adam steel RSS

    Reference to the measure itself in the formula (without IF)

    Глеб Aitov

      Hi,

       

      Let's say I want to calculate a measure SUM( Sales ), but I want to show only the numbers above certain threshold (the others should return Null).

       

      I can do it using if:

       

      if( SUM (Sales) < 100, SUM (Sales), Null() )

       

      Is there way to do the same without using IF, like using Set Analysis?

       

      Smth like: SUM (   {< SUM(Sales)<{100} >}    [Sales] )

       

      Thank you!