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
Hi Anonymous
Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.
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.