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

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

    Глеб Аитов



      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!