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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
StevenT
Helper V
Helper V

Matrix not calculating line items correctly.

Hi all. I see so many issues with the matrix incorrectly calculating values, now it's my turn to add my problem to the group.
when i calculate month to month % it works fine.
But when I attempt to calculate by Quarter over Quarter or Year over Year, incorrect Results.

My example below illustrates this.
For example, here is the matrix of one record
390/39 of course is not = to 1009.40

StevenT_2-1728571600560.png

 

Switching it from matrix to table doesn't change the %

StevenT_3-1728571600561.png

How do i resolve this so that the % are correctly calculating? Any ideas?

Always appreciate help.
Thanks, Steven Taub.

So it looks like the error is some how occuring before the data is actually posted into the visual. Rounding errors maybe?
Do you have any suggestions for me on resolving this?

Thanks...

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @StevenT ,

 

how do your measures look like?

How is the data model?

What result do you expect?

Can you provide a sample file?

 

If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.

 

Best regards

Denis

View solution in original post

3 REPLIES 3
StevenT
Helper V
Helper V

Actually, I was able to complete this task and I figured out what i was doing wrong. 
I was incorrectly identifying a measure that wasn't matching the Month Quarter and Year and I resolved it.

Thanks!

sanalytics
Super User
Super User

@StevenT Please provide some data. So that we can try from our end.

selimovd
Super User
Super User

Hey @StevenT ,

 

how do your measures look like?

How is the data model?

What result do you expect?

Can you provide a sample file?

 

If you want someone to help you, then add more details. Nobody knows why the result is like that if you don't tell which calculation you are using.

 

Best regards

Denis

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

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

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.