Chart and table showing different values

Question

Hi all,&nbsp;I'm having issues with a "YTD last year" measure.&nbsp;&nbsp;&nbsp;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:&nbsp;&nbsp;YTD Last year = CALCULATE([YTD];SAMEPERIODLASTYEAR('DATE'[DATE]))&nbsp;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.

joachim2108 · Answer

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.&nbsp;

anonymous · Answer

Hi&nbsp;Joachim2108&nbsp;,
&nbsp;
Please show some sample data. You could check the blog about&nbsp;How to Get Your Question Answered Quickly.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523&nbsp;
&nbsp;
Best Regards,
Jay

Forum Discussion

Chart and table showing different values

2 Replies

Related content

Date Different return wrong value

Row Total showing different value

Tooltip showing same values across different measures in Matrix visual

Measure showing different value in Table vs Card visual

Visual Calculation to show difference when there are blank values