0 Replies Latest reply on Apr 4, 2013 1:18 AM by Prakash Wilbert

    Set default value if no selection on measures

    Prakash Wilbert

      Hi,

       

      I am having list of ID and set of measures. I wanted to create a new calculated field  for ID in such a way that If there is no selection on any measure then set a default ID, otherwise show the IDs based on the selection. The reason why I am trying this because the the list of IDs are huge , hence it takes lot of time to load, but If i create this calculated field then the IDs will load only if any selection where made.

       

      Currently I tried with this logic , which doesn't work

       

      IF [<Measure1>]  = 'All' or [<Measure2>]  = 'All'  then IDs ='XXXXXXXX' else IDS = ID END.

       

      Thanks and looking forward for solution;