Forum Discussion
Total Amount not Accurate on Matrix
Hi! I was notified by one of our end users that the totals on a dashboard I created were ignoring certain rows. I checked it out and I'm currently at a loss because a lot of the columns correctly roll up the values to get the totals, but in a handful of them, they ignore certain ones. I don't have any filters on the matrix, and even if I did, I would think the row values wouldn't show up either if they weren't being added to the total. I'll include a screenshot of some examples and any help would be more than appreciated. Thanks!
Hi! Sorry for the delay, I ended up finding a solution by using SUMX as a function in my calculation. This allowed all the fields to properly roll-up and calculate correctly. Thank you for all your help!
Invoice Total (Fixed) =SUMX(VALUES('Invoices on Contracts'[sch_contract]),CALCULATE(SUM('Invoices on Contracts'[Invoice Total w/o Tax])))
5 Replies
- FBergamaschi
Super User
Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
Hi! Sorry for the delay, I ended up finding a solution by using SUMX as a function in my calculation. This allowed all the fields to properly roll-up and calculate correctly. Thank you for all your help!
Invoice Total (Fixed) =SUMX(VALUES('Invoices on Contracts'[sch_contract]),CALCULATE(SUM('Invoices on Contracts'[Invoice Total w/o Tax])))
v-prasareCommunity Support
Hi CalebG ,
We would like to follow up provide expected result as our super user requested for your sample data. Please let us know if you need any further assistance.
FBergamaschi , thanks for your prompt response.
Thanks,Prashanth Are
MS Fabric community support
- v-prasare
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,Prashanth Are
