I think you're on the right track there. If the documents containing location fields do not contain the consumption field, then a filter on the consumption field will filter out all of the location documents. Do you have multiple types for the sake of normalization? If so you may want to consider denormalizing a bit in order to make these types of queries possible. There isn't really a way to join across types.