Forum Discussion
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 ...
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,
Does this work?
=if(isblank('Baseline'[Baseline - CapEx]),blank(),MAX( 0,'Baseline'[Baseline - CapEx] - [Forecast CapEx]))
Ashish_Mathur It works in terms of producing the numbers I want, but the solution I found earlier was to bring fields in from a table other than my project fact table. Thank you.