2 Replies Latest reply on Apr 29, 2018 11:31 PM by nataraj.vijayanagaram

    Aggregated or Non-aggregated Measure selection based on Parameter


      Hello Experts,


      I am trying to create a calculated field that selects a measure based on parameter selection. Example below:


      if [Parameter] = "People" then [Value]

      elseif [Parameter] = "% Contribution" then [Contribution]

      else 0 end


      I have people as the # of people and Contribution is a calculated field that does Sum[Attendance]/Sum[Value]


      When I use the calculation, it shows me an error that cant merge aggregated value and non-aggregate value. However what I really want to do is refer to the measure dynamically based on value selected in [Parameter].


      Can you please advise how to fix this?


      Thank you!