Forum Discussion
Measure Causing my Table to Cross Join
Hi, In my datamodel, I have a table named Site Details with Unique Site IDs, and I have my Master Data table (See Picture). I created a measure with a simple Switch statement, but it is causing my t...
What is your join criteria and why do you have a blank value for site ID?
Site Details[Site ID] = Master Data[Site ID]
The Master Data have some Site IDs blank not the Site Details. The master data is mostly user input and the data quality is not so great.