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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
feralvarez994
Helper II
Helper II

Wrong totals

Hi everyone! I have a table with some measures that i have created. The thing is that the totals doesnt show the correct number that it should, i think its because it treats the negative numbers as positive and it sums every row without distinct of positive and negative numbers.

 

Im attaching the PowerBI File , the sheet that matters is the first one (Repuestos). The columns that show wrong totals are Importe Neto, IVA, Facturado and Costo Total. How can i do to get the right totals having in consideration the positive and negative numbers as they truely are?

feralvarez994_0-1658331562999.png

 

Thanks everyone!

 

PowerBI File 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

3 REPLIES 3
feralvarez994
Helper II
Helper II

@tamerj1  thanks a lot! it works fine, can you tell me why should i write first sumx and summarize? or why does the table didnt sum correctly?

@feralvarez994 
You need to simulate the current filter context inside then sum the visible values as you see it in the matrix.

tamerj1
Super User
Super User

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!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.