cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate III
Advocate III

Row totals are duplicating, Grand Total is Correct

I have an issue where the row totals are overstated but the grand total is correct. The source is a tabular model and when I connect Excel to the model in a pivot table, everything is correct but for some reason Power BI is duplicating the row totals. The underlying measure is a SUMX. Any ideas on what might be going on?

JamesBI_0-1598565803176.pngJamesBI_1-1598565887382.png

 

4 REPLIES 4
Community Champion
Community Champion

Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.


Hope it resolves your issue? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Microsoft
Microsoft

Hi @JamesBI ,

 

This is related to how you use the filter conditions in the sumx function.

You can search the forums for how to create measure that meet your requirements.

If the problem persists, please provide more details to let us know about your scenario.

 

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

Super User IV
Super User IV

@JamesBI , without looking at data difficult to say.

 

but if you are using a formula like

 

sumx(Table, sum(Table[value]))

 

use like

sumx(Table, calculate(sum(Table[value])))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hello all. Sorry for the late response. I deleted all my relationships and started over. It appears that one of my relationships was causing the issues. Thanks so much for your help!

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors