Forum Discussion
Measure is creating duplicate rows in a table
Anonymous , Couple of reasons I can think of.
1. These measures are coming from different tables and one of them have a problem with project join
2. Both table has project ID, and there is a common project table(Project Dimension) and you took project or project name from a fact, not from Dimension
3. One of the measures is using all/all selected. even possible when they are from the same table
Anonymous No, I can't actually, due to confidentiality. I was hoping that someone would recognize the behavior and maybe provide some clues as to what could be causing this behavior.
If that's not you; thanks anyway for trying.
Anonymous , Couple of reasons I can think of.
1. These measures are coming from different tables and one of them have a problem with project join
2. Both table has project ID, and there is a common project table(Project Dimension) and you took project or project name from a fact, not from Dimension
3. One of the measures is using all/all selected. even possible when they are from the same table
amitchandak Good call! It looks like using the Project ID and some other fields from a fact table was causing the problem.
Thank you.