MDX Implementing Logical AND On Members of the Same Hierarchy

In my prior blog post, I discussed implementing logical OR in MDX on members of different hierarchies. As a follow-up to that post, I will now demonstrate how to implement logical AND on members of the same hierarchy. If you have not read my prior post, I recommend doing so before proceeding.

In MDX, when two or more members of the same set are placed on a slicer, OR logic is automatically applied. For example, if you have two members (e.g. sizes 'Small' and 'Large') on a slicer, the resulting dataset will contain data where the first, second or both members occurred in the associated fact table. Similarly, a tuple formed by members of multiple hierarchies (e.g. size 'Small' and color 'Red') will only return results that have data associated to both members; AND logic is applied in this instance.