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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
StevenT
Resolver I
Resolver I

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
Resolver I
Resolver I

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
Solution Sage
Solution Sage

@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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.