Different subtotal value in matrix when expanding row

[RussRoberts]

Hi there, I have a matrix that is displaying a different value in one cell when the groupon the row is expanded.

The Matrix has the fees earned by department each day of the month. When expanding the row it displays the braekdown of the fees for the Consultants within that department.

Here I have highlighed the cell and you can see the correct value on the card in the top right.

Expanding the row then changes the value

This report is published to web. When I view the same report in Desktop or within the Workspace the values are correct in both states. This is Desktop and not expanded.

The data is coming from an SQL database view of individual calendar events with the Consultant, date and value. There are no relationships setup for this view in PowerBI and the filters on the Card and Matrix are exactly the same.

Columns: Start Date (DateTime)

Rows: Region, AssignedTo (Strings)

Values: Sum or Value

Any help or pointers would be greatly appreciated.

[AlexisOlson]

That's pretty weird. Maybe the wrong value is a cached value from an earlier point in time? Does refreshing the page or resetting it to default change it at all?