10 Replies Latest reply: Jul 3, 2017 5:10 PM by Stefan Wühl RSS

    How to have COUNT (TOTAL..) to ignore one selection.

    Marco B

      I have the following measure expression:

       

      COUNT(OrderItemId) / COUNT(TOTAL < [PaidDate.Calendar.YearMonth] > OrderItemId)

       

      But wanted for the total on the denominator (above) not to change when the dimension [ManufacturerName] is selected.

       

      What can I include below to ignore the [ManufacturerName] selection:

       

      COUNT(TOTAL < [PaidDate.Calendar.YearMonth] > OrderItemId)