Different subtotal value in matrix when expanding row

RussRoberts — Tue, 18 Jun 2024 14:05:29 GMT

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.

Re: Different subtotal value in matrix when expanding row

AlexisOlson — Tue, 18 Jun 2024 17:18:03 GMT

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?

topic Different subtotal value in matrix when expanding row in DAX Commands and Tips

Different subtotal value in matrix when expanding row

Re: Different subtotal value in matrix when expanding row