4 Replies Latest reply on Dec 4, 2018 7:48 AM by Sasha Hanna

    Swap Measure using Parameters - mixing aggregate and non aggregate comparisons

    Al Genin

      Trying to build a measure select using a parameter with a case when, and I'm getting the 'cannot mix aggegate and non-aggregate...' error:

       

      CASE [Metric Select]

      WHEN 'Capture' then [Capture]

      WHEN 'Discounts' then [Discounts]

      WHEN 'POR (Gross)' then [POR (Gross)]

      WHEN 'POR (Net)' then [POR (Net)]

      WHEN 'Sales (Gross)' then [Sales (Gross)]

      WHEN 'Sales (Net)' then [Sales (Net)]

      WHEN 'Transactions' then [Transactions]

      WHEN 'Units' then [Units]

      WHEN 'UPT' then [UPT]

      END

       

      Any way around this?  I think the aggregate error is coming from some of the KPIs like POR, which is dividing revenue by rooms (it's a hotel).