Service displaying incorrect data

[jthomson]

Hi,

Have got an odd situation that's been appearing within a report in the service over the last couple of weeks. Basically I have a bunch of high level measures/calculations on an opening page, which are displayed within in a matrix, and the row headers are simply a column in the main table of my data model which is concatenating two text fields, one for a main supplier name and one for the year of business. This works perfectly within the desktop .pbix and all the values are correct there, however upon publishing to the service, the overall sums of each measure still tally, but the individual rows are producing different amounts, as if the column used in the row headers is working differently. Has anyone ever experienced anything like this?

Desktop:

Service:

Totals are ever so slightly off due to synching issues, but note (say) the third line from bottom, where the last columns are both showing as 22 million something, but looking at the desktop they should be 25 million and 27 million respectively

[v-henryk-mstf]

Hi @jthomson ,

What is the exact formula created and is the relevant date field referenced? Also is there a slicer that uses a similar relative date, which may cause errors in the statistics due to differences in UTC.

If the problem is still not resolved, please provide detailed error information and test data(include created formula). Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.