Sum of columns getting different value when compare to normal calculation

[Rockz]

Dear champions ,

I have 2 columns which is being used in a matrix visual. when I'm trying to do sum of monthly bike sales but I'm getting different total when compare to normal calculation.

Thanks in advance!

[Anonymous]

Hi @Rockz ,

Thank you for @sanalytics answer,and I have other suggestions:

In Power BI, for total and subtotal rows, the measure is evaluated over all rows in the underlying data, not just a simple addition of the values in the visible or displayed rows. This means the total row might display different values than you might expect, especially if the value you’re summing is on the ‘one’ side of a one-to-many relationship.

Here are a couple of steps you can take:

   Ensure that the relationship between the tables (if your data model involves multiple tables) is correctly set up. A common cause for unexpected totals is a misunderstanding or misconfiguration of the data model, especially in how tables relate to each other.

Below is the official link will help you:

Create a matrix visual in Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sanalytics]

Hello @Rockz 

Try this measure

ForTotal = Sumx( Values(Period[Period] ),[ Monthly bikes sales] )

Assuming your period column is coming from Period Table.

Regards

sanalytics

If it is your solution then please like and accept it as solution