Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Tips and Tricks
Tutorial Requests
  • Gordonlilj's avatar
    Gordonlilj
    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])

     

     

     

     

Gordonlilj's avatar
Gordonlilj
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

 

Try adding 'Unique Projects Data Model'[Phase] = "8. Cash Collected" instead of "8. Cash Collected"

 

 

 

Earned = CALCULATE('Unique Projects Data Model'[Total Nominal Budget],FILTER('Unique Projects Data Model', 'Unique Projects Data Model'[Phase] = "7. Sold" || 'Unique Projects Data Model'[Phase] = "8. Cash Collected"))

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Is it possible for you to share some sample data?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Gordonlilj 

       

      I am not sure how to share the file, shall I take screenshots of some of the tables/measures/others?

       

      • Gordonlilj's avatar
        Gordonlilj
        Icon for Solution Sage rankSolution Sage
        6 years ago

        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