Forum Discussion
Measure creates cartesian
I'm trying to understand why this measure is creating a cartesian product. It's simple to reproduce: Two tables Dim and Fact. Dim has only a DimId column, fact has dimId and a date column. Measu...
What are you trying to do here? Where are the dim IDs coming from - the ones placed on rows and columns? It looks like you have dim ID coming from both tables in this visual. Why are you doing that and what do you expect to achieve? The dim ID from your fact table will not filter your dimension table. That is why you have a cartesean join
did you try to reproduce the issue here? takes a couple minutes to create the data model I've posted.
I've had no luck and it makes no sense to me.