Total Not Graphed Completely

[Anonymous]

I have a table of users and their YTD revenue goals. I needed this broken out monthly so I simply took the YTD number and divided by 12. I know the sum for all users is supposed to be this by the end of the year:

However, when I graph the above number I get a different total:

A difference of 40,000. After some digging around, I discovered that it falls short on a graph because there is one user that does not have any December dates in their data:

I know if I wait it out and she finally gets some data for December the graph will show the full number, but is there any way I can display the full number reagrdless of this user not having December dates? If the full number displays on a card but only most of it displays on a graph, that is going to confuse people when looking. Here's what my cumulative formula looks like:

Which in a table looks like this:

So as you can see, for some reason it will return the complete total at the bottom, but not in the December number where I expected it to be.

Measure 3 is just YTD_Goal/12. There is a relationship between my date table and my main table above (date->value).

[v-lili6-msft]

hi @Anonymous 

This looks like a measure totals problem. Very common. See this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

For you case, you discovered that it falls short on a graph because there is one user that does not have any December dates in their data

Yes, it is the main problem for it.

and it should be that there is no year filed in the table visual, so it show data for this result, the different result is due to Row Context in power bi.

And I think 4482000.00 is wrong result and 4442000.00 is right result.

By the way, if you should use this formula in cumulative measure

Cumulative Quota = SUMX('Table',[Measure 3]*CALCULATE(MAX('Date'[Month])))

Regards,

Lin