Sum of table column

[k33fun]

Hi 

I am using a table visual and below is my result for Total table row

Gross Sales (MYR) Dax is [Quantity] * [Unit Price]

But the sum of Gorss Sales (MYR) row is not correct, it should be 10,531,720

Now it is taking sum of Quantity 14,137 * Sum of Unit Price 247,272 = 3,495,684,264

Can suggest for any solution for this?

[powerbidev123 · Accepted solution]

@k33fun , Use SUMX in your DAX. What your measure is doing is just multiplying plainly with quantity to unit price

[anmolmalviya05 · Accepted solution]

Hi @k33fun, Hope you are doing good!

The issue you're facing arises because the calculation for Gross Sales (MYR) in the total row is aggregating the quantities and unit prices first, then multiplying the sums, which is not the correct logic. To fix this, you need to ensure that the calculation for Gross Sales (MYR) is performed row by row in the table before summing up.

Here’s how to resolve this:

Instead of creating a calculated column, create a measure that calculates Gross Sales (MYR) correctly at all levels, including the total:

Gross Sales (MYR) =

SUMX(

'FactTable',

'FactTable'[Quantity] * 'FactTable'[Unit Price]

)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for more Power BI and Microsoft Fabric Updates: https://www.youtube.com/@AnmolPowerBICorner

[v-csrikanth]

HI @k33fun 

It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @k33fun 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @k33fun 
Sorry for the late response.
As highlighted by @Ajithkumar_P_05 @anmolmalviya05 , the proposed approach appears to effectively address your requirements.
Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best regards,

Cheri Srikanth.

[Ajithkumar_P_05 · Accepted solution]

Use SUMX instead of SUM.

[anmolmalviya05 · Accepted solution]

Hi @k33fun, Hope you are doing good!

The issue you're facing arises because the calculation for Gross Sales (MYR) in the total row is aggregating the quantities and unit prices first, then multiplying the sums, which is not the correct logic. To fix this, you need to ensure that the calculation for Gross Sales (MYR) is performed row by row in the table before summing up.

Here’s how to resolve this:

Instead of creating a calculated column, create a measure that calculates Gross Sales (MYR) correctly at all levels, including the total:

Gross Sales (MYR) =

SUMX(

'FactTable',

'FactTable'[Quantity] * 'FactTable'[Unit Price]

)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for more Power BI and Microsoft Fabric Updates: https://www.youtube.com/@AnmolPowerBICorner

[powerbidev123 · Accepted solution]

@k33fun , Use SUMX in your DAX. What your measure is doing is just multiplying plainly with quantity to unit price