Forum Discussion
Anonymous
6 years agoNot applicable
Measure for "Earned" returns wrong value
Hi, I am new to Power BI, so apologies if I am doing something completely wrong. I have a table in which each row is a project. Each project has a column called "Phase" which has the foll...
- 6 years ago
My first guess to the issue would be that you're using a hidden table with no relation between the other tables.
Using Unique Projects Data Model instead gives me the result you mentioned
Total Nominal Budget = SUM('Unique Projects Data Model'[Current Client Budget])
Anonymous
6 years agoNot applicable
Gordonliljit still returns a wrong value.
It seems that it simply returns the [Total Nominal Budget] although I am trying to filter by the specific "Phase".
Gordonlilj
Solution Sage
6 years agoIs it possible for you to share some sample data?
- Anonymous6 years agoNot applicable
I am not sure how to share the file, shall I take screenshots of some of the tables/measures/others?
- Gordonlilj6 years ago
Solution Sage
To share the file you would could use an online file sharing tool like onedrive or dropbox.
Though sharing the file would be better, screenshots should work fine as well
- Gordonlilj6 years ago
Solution Sage
Forgot to ask but what is the expected value?