Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
@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
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.
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? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@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.
@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
@amitchandak Good call! It looks like using the Project ID and some other fields from a fact table was causing the problem.
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |