cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

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 it's also creating additional rows (with the same project ID I filtered on) for every Project Name. My guess is that this behavior is due to how the data model is configured, but I wanted to reach out to see if anyone has seen this before and has a DAX workaround.

Release CapEx = 
MAX( 0,'Baseline'[Baseline - CapEx] - [Forecast CapEx])
 

Capture.JPG


 
 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

@bchager6 , 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

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

6 REPLIES 6
Highlighted
Community Champion
Community Champion

Hi @bchager6 

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.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted

@pranit828 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.

Highlighted

@bchager6 , 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

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Super User III
Super User III

Hi,

Does this work?

=if(isblank('Baseline'[Baseline - CapEx]),blank(),MAX( 0,'Baseline'[Baseline - CapEx] - [Forecast CapEx]))


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Highlighted

@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.

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors