I'm working on an expression/measure to count the number of reservations with Air AND either Car or Hotel. See attached data set example. I'm using Column E as the identifier as it will be same for the reservation elements (Air, Car, Hotel). I need to count those that have both Air and Car or Hotel. As a reference I'm using the following to count Air transactions:
Count(Distinct{$<[Booking Type] = {'Air'}, [Transaction Type] = {'Sale'}>} [Record Locator])
I tried to single out Car/Hotel without Air using the following but it did not work:
Count(Distinct{<[Record Locator] = {'>1'}, [Booking Sub Type] += {'Car','Hotel'}, [Booking Type] -= {'Air'}, [Transaction Type] = {'Sale'}>} [Record Locator])
Any suggestions would be greatly appreciated. Thanks!