Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure is creating duplicate rows in a table

All,   I created a measure to return the greater of 0 or the difference Between Baseline - CapEx and Forecast CapEx. The measure is returning the correct value for each Project ID I filter on, but ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

amitchandak  Good call! It looks like using the Project ID and some other fields from a fact table was causing the problem. 
Thank you.