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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AsihwaryaS
Regular Visitor

Row subtotals are displayed wrong for negative values

Dear Team,

 

The row subtotal in the matrix is displaying wrong summation values for columns with negative values.

Please have a look at the below table. Could you please let me know how to resolve this?

 

AsihwaryaS_0-1681288952076.png

 

5 REPLIES 5
joaoribeiro
Kudo Kingpin
Kudo Kingpin

Hi @AsihwaryaS , in this case what's the desired total? Should it be the sum of all rows? Currently, Power BI is replicating the summarization, which means that it's recalculating the "bud %" for all values.

Also, please share some data sample if you can, to help solving the issue 🙂


If you need any additional help please @ me in your reply.

Thanks!

Best regards,
Joao Ribeiro

Hello,

 

The desired total would be -9.20% for Bud% and 30.0% for LY%

 

Normal summation of all the values in a column

 

Regards,

Aishwarya S

Hi @AsihwaryaS , thank you.

 

In this case, you can use the IF(ISINSCOPE()) to check if you are in a line or in the total, and if you're in the total you consider the sum instead of the normal calculation. Please, consider the code below as starting point, replicate for the LY%, and adjust as you need:

bud % sum = 
IF(
// Check if it is in the item lines, if so, consider the normal 'bud %' measure
ISINSCOPE('Table'[Item]),
[bud %],
// If it is not in the lines, consider the sum of the lines
SUMX('Table', [bud %])
)

Example of result:

joaoribeiro_0-1681291109965.png


Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍

Thanks!

Best regards,
Joao Ribeiro

Hi,

 

I applied the above formula but my total is blank, not sure if its because my values are in percentage

Hi @AsihwaryaS , can you plase share a small sample of the data? Thank you.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors