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?