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 Barroso

      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)