I am new to MDX and I have already tried Google to find a solution for my query but didn't get any answer by myself.
For the use case, I have a role-play dimension (geography), a customer and store. Geography is used both in customer and store.
I want to figure out, how many people take effort to drive a long distance to get to the store.
In SQL, I would just use a WHERE condition with store.location <> customer.location.
How do I do it in MDX? I used the Cube Browser from SMSS but there no GUI solution for that. I tried Excel Pivot but I couldn't do it there, either.
Thanks for your help!