Chart and table showing different values

[Joachim2108]

Hi all,

I'm having issues with a "YTD last year" measure.

I have the same measures presented on a chart and table, however as you can see on the picture, the YTD last year values are different, while the YTD (current year) values are correct and the same. The YTD last year values are correct on the chart, not the table. The DAX formula for YTD last year is: 

YTD Last year = CALCULATE([YTD];SAMEPERIODLASTYEAR('DATE'[DATE]))

The solution is probably very simple, however I can't seem to figure it out. Can anyone tell me why the table shows different values, and how do I fix it?? Thanks in advance.

[Anonymous]

Hi @Joachim2108 ,

Please show some sample data. You could check the blog about How to Get Your Question Answered Quickly.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,

Jay

[Joachim2108]

Followup: I understand the issue has something to do with how PBI calculates totals, however the solutions to these problems are different depending on the context.