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

    Aggregated or Non-aggregated Measure selection based on Parameter

    nataraj.vijayanagaram

      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!