Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
RussRoberts
New Member

Different subtotal value in matrix when expanding row

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.

RussRoberts_0-1718718920394.png
Expanding the row then changes the value

RussRoberts_1-1718719101455.png

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.

RussRoberts_2-1718719288029.png

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

 

RussRoberts_3-1718719384106.png

 

Any help or pointers would be greatly appreciated.

 

1 REPLY 1
AlexisOlson
Super User
Super User

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?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors